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
