fechas de string a date
Publicado por luis (6 intervenciones) el 25/07/2019 13:58:25
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
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
-1