SQL SERVER DE STRING A DATE
Publicado por luisarg10 (1 intervención) el 25/07/2019 16:45:49
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
use examen
create table CGECHEQUES
(Id_cheques int identity primary key,IdCheque int,Estatus int,FECHA varchar(50),
)ALTER TABLE CGECHEQUES
ALTER COLUMN CGECHEQUESIDENTITY varchar(50);
insert into CGECHEQUES values(314769, 1,'202127')
insert into CGECHEQUES values(67899, 4, '202127')
insert into CGECHEQUES values(99999, 5,'212121')
insert into CGECHEQUES values(79999, 5,'202127')
insert into CGECHEQUES values(78899, 5,'202127')
insert into CGECHEQUES values(7889, 5,'202127')
select *from CGECHEQUESUPDATE CGECHEQUES
SET Estatus = 5WHERE IdCheque in (314769,67899,7889)
AND Estatus = 4AND FECHA = 202127create table acmcc
(id_acmcc int identity primary key,cfapecue varchar(50),
)create table ACMCC_0619
(id_acmcc int identity primary key,cfapecue varchar(50),
)select *from ACMCC_0619select * from acmccinsert into acmcc values('050111')
insert into acmcc values('030290')
insert into acmcc values('010596')
insert into acmcc values('010200')
//tabla acmcc
// tabla ACMCC_O619
insert into ACMCC_O619 values('050111')
insert into ACMCC_O619 values('030290')
insert into ACMCC_O619 values('010596')
insert into ACMCC_O619 values('010200')
fecha CFEAPECUE del 1995/06/01 al 2002/04/05
select * from acmcc where cfapecue between '050111'
and '090111'select '050111' cfapecue into #acmcc
insert into #acmcc values('260191')
select * from #acmcc
select *from acmccselect case when right(right(('0'+cfapecue),6),2)<57 then '20'+right(right(('0'+cfapecue),6),2)+'/'+ substring(right(('0'+cfapecue),6),3,2)+'/'+left(right(('0'+cfapecue),6),2)
else '19'+right(right(('0'+cfapecue),6),2)+'/'+ substring(right(('0'+cfapecue),6),3,2)+'/'+left(right(('0'+cfapecue),6),2) end fecha from #acmcc
select * from #acmcc where cfapecue between '010191' and '060111'
select * from #acmcc where case when right(right(('0'+cfapecue),6),2)<57 then '20'+right(right(('0'+cfapecue),6),2)+'/'+ substring(right(('0'+cfapecue),6),3,2)+'/'+left(right(('0'+cfapecue),6),2)
else '19'+right(right(('0'+cfapecue),6),2)+'/'+ substring(right(('0'+cfapecue),6),3,2)+'/'+left(right(('0'+cfapecue),6),2) end between '1991/01/01' and '2011/01/30'
update #acmcc set cfapecue='100111' where cfapecue='00111'
select *from #acmcc
select* from #acmcc where cfapecue =DATEDIFF ( d,'01/01/1957', '17/07/2019')
select DATEadd ( d, cast(cfapecue as int),'01/01/1957') from #acmcc
select DATEadd ( d, convert(int ,cfapecue),'01/01/1957') from #acmcc
select DATEadd ( d, convert(int ,cfapecue),'01/01/1957') from #acmcc
select * from ACMCC_0619;-- comentarios
select
(CASE WHENRIGHT((RIGHT(('00'+CAST(CFEAPECUE AS VARCHAR(6))),6)),2)<57 THEN '20' ELSE '19' END)
+RIGHT((RIGHT(('00'+CAST(CFEAPECUE AS VARCHAR(6))),6)),2)
+'/'+SUBSTRING((RIGHT(('00'+CAST(CFEAPECUE AS VARCHAR(6))),6)),3,2)
+'/'+
LEFT((RIGHT(('00'+CAST(CFEAPECUE AS VARCHAR(6))),6)),2)
FECHA from ACMCC_0619
WHERE (CASE WHENRIGHT((RIGHT(('00'+CAST(CFEAPECUE AS VARCHAR(6))),6)),2)<57 THEN '20' ELSE '19' END)
+RIGHT((RIGHT(('00'+CAST(CFEAPECUE AS VARCHAR(6))),6)),2)
+'/'+SUBSTRING((RIGHT(('00'+CAST(CFEAPECUE AS VARCHAR(6))),6)),3,2)
+'/'+
LEFT((RIGHT(('00'+CAST(CFEAPECUE AS VARCHAR(6))),6)),2) <'2009/07/24'
Valora esta pregunta
0