Excellent. I did not see that. Thank you
2010/10/6 Thomas Kellerer <spam_ea...@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 >
