1 2 3 4 5 6 7
| SELECT cast(ageges as smallint) as mag, nocmpt as compte, cast(substr(dtdem, 1, 4)||'-'||substr(dtdem, 5, 2)||'-'||substr(dtdem, 7, 2) as date) as dtdem, cast(substr(dtrefa, 1, 4)||'-'||substr(dtrefa, 5, 2)||'-'||substr(dtrefa, 7, 2) as date) as dtrefa, cast(substr(dtdeli, 1, 4)||'-'||substr(dtdeli, 5, 2)||'-'||substr(dtdeli, 7, 2) as date) as dtdeli, cast(substr(dtannu, 1, 4)||'-'||substr(dtannu, 5, 2)||'-'||substr(dtannu, 7, 2) as date) as dtannu, etchqr
FROM pack10pdta.chqchqp000
WHERE dtdeli=' ' and dtrefa<>' ' and dtannu =' '
ORDER by ageges, nocmpt |
Partager