Netezza SQL syntax to convert numeric YYYYMMDD format into date

sql netezza
Allan Bowe picture Allan Bowe · Jul 31, 2009 · Viewed 58.8k times · Source

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

?

Answer

user447151 picture user447151 · Sep 14, 2010

You can use this one as it's the best one.

SELECT TO_DATE('20090731','YYYYMMDD') as NZDATE

Related questions

How to delete duplicate rows without unique identifier

I have duplicate rows in my table and I want to delete duplicates in the most efficient way since the table is big. After some research, I have come up with this query: WITH TempEmp AS ( SELECT name, ROW_NUMBER() …

Read More
How do I list all the column names in Netezza?

Is there a query I can write to search all the column names for a particular database in Netezza?

Read More
Inserting multiple rows into a table using a single INSERT statement

I have no idea why I cannot insert values into my table using this syntax. I can insert one row but I cannot insert multiple rows. CREATE TABLE T1 ( ID BIGINT NULL, CAT VARCHAR(255) NULL, M_ID BIGINT NULL, T_…

Read More