> 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' > > Any help would be greatly appreciated.
Try this: WHERE pt.created_date >= '2008-01-21'::date -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
