Обсуждение: Create Datefield from 3 fields
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
"1966526-01-01"
"7991903-12-13"
"1962831-01-01"
"194611-01-01"
"196211-01-01"
Any ideas on how to do this?
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
Excellent. I did not see that.
Thank you
Thank you
2010/10/6 Thomas Kellerer <spam_eater@gmx.net>
Andreas Forø Tollefsen, 06.10.2010 13:11:You are missing the dashes in the input string that you specify in the format maskHi.
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 cshapesThomas
to_date(gwsyear::text ||'-'|| gwsmonth::text ||'-'|| gwsday::text, 'YYYY-MM-DD')
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql