1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| select * from (
select DUMP,
substr(DUMP, instr(DUMP,':',1,1)+2, instr(DUMP,',',1,1)-2-instr(DUMP,':',1,1)) Siecle,
substr(DUMP, instr(DUMP,',',1,1)+1, instr(DUMP,',',1,2)-1-instr(DUMP,',',1,1)) Annee,
substr(DUMP, instr(DUMP,',',1,2)+1, instr(DUMP,',',1,3)-1-instr(DUMP,',',1,2)) Mois,
substr(DUMP, instr(DUMP,',',1,3)+1, instr(DUMP,',',1,4)-1-instr(DUMP,',',1,3)) Jour,
substr(DUMP, instr(DUMP,',',1,4)+1, instr(DUMP,',',1,5)-1-instr(DUMP,',',1,4)) Heure,
substr(DUMP, instr(DUMP,',',1,5)+1, instr(DUMP,',',1,6)-1-instr(DUMP,',',1,5)) Minute,
substr(DUMP, instr(DUMP,',',1,6)+1) Seconde
from (select dump(DATE_CREATION) DUMP from comptes_gesop@test9)
where not seconde between 1 and 60
or NOT minute between 1 and 60
or NOT heure between 1 and 24
or NOT jour between 1 and 31
or not mois between 1 and 12
or not annee between 100 and 199
or not siecle between 119 and 120 ; |
Partager