am Tue, dem 11.03.2008, um 10:51:21 -0700 mailte CaseT folgendes: > Hi All, > > I'm a novice but learning quickly and I'm stumped on how to do this. > > I need to convert postgres timestamp to date format yyyy-mm-dd in a > sql statement. > pt.created_date below is timestamp format > > i.e ... WHERE pt.created_date >= '2008-01-21'
You can't compare a date or timestamp to a varchar or text. For your example, cast the date-string to a real date like: ... WHERE pt.created_date >= '2008-01-21'::date Consider also functions like to_date(), see: http://www.postgresql.org/docs/current/static/functions-formatting.html Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
