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;