Skip to content
Advertisement

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

?

Advertisement

Answer

Easiest way to convert number to date would be

select  date(to_char(20090731,'99999999')) as Number_As_DATE;
User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement