RawFocus RawFocus - 19 days ago 5
SQL Question

Netezza SQL syntax to convert numeric YYYYMMDD format into date

We have a Netezza table that contains dates stored in a numeric YYYYMMDD format (eg 20090731).

What is the best Netezza syntax to use to convert this into date format?

eg

SELECT somefunction(20090731) as NZDATE


?

Ian Ian
Answer

Easiest way to convert number to date would be

select  date(to_char(20090731,'99999999')) as Number_As_DATE;
Comments