This example casts the numeric integer expression to a date format.
SELECT CAST (1071201 AS DATE);
The result looks like this when the DateForm mode of the session is set to ANSIDate:
1071201 ---------- 2007-12-01
This example casts the numeric integer expression to a date format.
SELECT CAST (1071201 AS DATE);
The result looks like this when the DateForm mode of the session is set to ANSIDate:
1071201 ---------- 2007-12-01