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?
SELECT somefunction(20090731) as NZDATE
Easiest way to convert number to date would be
select date(to_char(20090731,'99999999')) as Number_As_DATE;