91
iSeries / Re: Unix Timestamp
« on: October 25, 2006, 10:08:24 AM »
our DBA is using castdate function
SELECT SUBSTR(APPLID,1,8)
,CAST('1969-12-31' AS DATE) + PDATE DAYS
,RIGHT((' ' || STRIP(DIGITS(COUNT(*)),LEADING,'0')),9)
,PDATE
,DNAME
,DNAME_WHOLE
,B.NAME
FROM SROLSHE.DIRECTORY , ARSSERVR.ARSNODE B
WHERE (SUBSTR(APPLID,1,8) = 'LEBLL01P'
OR SUBSTR(APPLID,1,8) = 'LECHK01P')
AND (CAST('1969-12-31' AS DATE) + PDATE DAYS) > '1997-12-31'
AND (CAST('1969-12-31' AS DATE) + PDATE DAYS) < '2006-02-12'
AND NID = PRI_NID
GROUP BY
APPLID
,PDATE
,DNAME
,DNAME_WHOLE
,B.NAME
WITH UR;
SELECT SUBSTR(APPLID,1,8)
,CAST('1969-12-31' AS DATE) + PDATE DAYS
,RIGHT((' ' || STRIP(DIGITS(COUNT(*)),LEADING,'0')),9)
,PDATE
,DNAME
,DNAME_WHOLE
,B.NAME
FROM SROLSHE.DIRECTORY , ARSSERVR.ARSNODE B
WHERE (SUBSTR(APPLID,1,8) = 'LEBLL01P'
OR SUBSTR(APPLID,1,8) = 'LECHK01P')
AND (CAST('1969-12-31' AS DATE) + PDATE DAYS) > '1997-12-31'
AND (CAST('1969-12-31' AS DATE) + PDATE DAYS) < '2006-02-12'
AND NID = PRI_NID
GROUP BY
APPLID
,PDATE
,DNAME
,DNAME_WHOLE
,B.NAME
WITH UR;