On Jun 12, 2007, at 4:04 , Adam Witney wrote:
bugasbase_070529=# insert into date_test values('Wed Jul 11 10:51:14
GMT+01:00 2001');
ERROR: invalid input syntax for type date: "Wed Jul 11 10:51:14 GMT
+01:00
2001"
I have found date_trunc and extract in the docs,
Both date_trunc and extract work on date and timestamp datatypes.
What you are looking for is something to convert a string to a date:
to_date should work:
http://www.postgresql.org/docs/8.2/interactive/functions-formatting.html
Michael Glaesemann
grzm seespotcode net