Postgres Pro
Downloads
Home   >   mailing lists

Re: Create Datefield from 3 fields - Mailing list pgsql-sql

From Andreas Forø Tollefsen
Subject Re: Create Datefield from 3 fields
Date
Msg-id AANLkTimUu=E7G4yd3r6F0T-Nq3065KWKoXV31-6+T=uq@mail.gmail.com
Whole thread Raw
In response to Re: Create Datefield from 3 fields  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-sql
Tree view
Excellent. I did not see that.

Thank you

2010/10/6 Thomas Kellerer <spam_eater@gmx.net>
Andreas Forø Tollefsen, 06.10.2010 13:11:

Hi.

I am trying to create a datefield using YEAR, MONTH and DAY fields of type integer.
I tried this query, but it did not give good results:
select to_date(gwsyear::text || gwsmonth::text || gwsday::text, 'YYYY-MM-DD') FROM cshapes

You are missing the dashes in the input string that you specify in the format mask


 to_date(gwsyear::text ||'-'|| gwsmonth::text ||'-'|| gwsday::text, 'YYYY-MM-DD')


Thomas


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

pgsql-sql by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Create Datefield from 3 fields
Next
From: Gary Chambers
Date:
Subject: Duplicates Processing