Re: [SQL] Create Datefield from 3 fields

2010-10-06 Thread Andreas Forø Tollefsen
Excellent. I did not see that. Thank you 2010/10/6 Thomas Kellerer > 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

Re: [SQL] Create Datefield from 3 fields

2010-10-06 Thread Thomas Kellerer
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, '-MM-DD') FROM cshapes You are missing t