Home > mailing lists

Create Datefield from 3 fields - Mailing list pgsql-sql

From	Andreas Forø Tollefsen
Subject	Create Datefield from 3 fields
Date	October 6, 2010 11:11:12
Msg-id	AANLkTimswkQCUiZMT4EGkE-w5XKv5mgd3RcfdnT-N8QF@mail.gmail.com Whole thread Raw
Responses	Re: Create Datefield from 3 fields (Thomas Kellerer <spam_eater@gmx.net>)
List	pgsql-sql

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?

From: "Ozer, Pam"
Date: 04 October 2010, 15:40:55
Subject: Re: Random sort with distinct

From: Thomas Kellerer
Date: 06 October 2010, 11:36:36
Subject: Re: Create Datefield from 3 fields