syntax for replacement of CAST/FROM_TZ

[blom0344]

I just found out that Oracle8 does not support the CAST expression. The following works quite nicely in 9i:

CASE WHEN DS_PENDING_JOB.JOB_STATUS In (2, 3, 4, 6, 1006) THEN to_date(null) ELSE (from_tz(CAST(to_date('15/12/1970','DD/MM/YYYY')+(DS_PENDING_JOB.START_DATETIME/(24*60*60)) as TIMESTAMP), 'GMT') AT LOCAL) END

Is there a guru who can tell what the equivalent would be in Oracle 8?

Ties Blom

 

[Dagon]

Use decode:

SELECT DECODE(DS_PENDING_JOB.JOB_STATUS , 2, TO_DATE(NULL), 3, TO_DATE(NULL), 4, TO_DATE(NULL), 6, TO_DATE(NULL), 1006, TO_DATE(NULL),
(from_tz(CAST(to_date('15/12/1970','DD/MM/YYYY')+(DS_PENDING_JOB.START_DATETIME/(24*60*60)) as TIMESTAMP), 'GMT') AT LOCAL)) X
FROM DUAL

 

[blom0344]

Uh,

The problem is with the CAST (not CASE)

Version 8 does not allow me to cast a date as a TIMESTAMP, whereas this is perfectly possible in 9i..

Ties Blom