Victor Sterpu wrote:
> When I run the query from down I receive an error.
> How can I write this query to receive the day ot the week.
> SELECT EXTRACT(DOW FROM timestamp TO_TIMESTAMP('14-10-2011', 'DD-MM-YYYY'));
Maybe you mean
SELECT EXTRACT(DOW FROM TO_TIMESTAMP('14-10-2011', 'DD-MM-YYYY'));
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
