Re: Create Datefield from 3 fields
От
Thomas Kellerer
Тема
Re: Create Datefield from 3 fields
Дата
Msg-id
i8hmvg$mqd$1@dough.gmane.org
Ответ на
Create Datefield from 3 fields (Andreas Forø Tollefsen)
Список
Дерево обсуждения
Create Datefield from 3 fields Andreas Forø Tollefsen <andreasft@gmail.com>
Re: Create Datefield from 3 fields Thomas Kellerer <spam_eater@gmx.net>
Re: Create Datefield from 3 fields Andreas Forø Tollefsen <andreasft@gmail.com>
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
В списке pgsql-sql по дате отправления
