Re: Query with error - DOW FROM timestamp

[Albe Laurenz <laurenz.albe@xxxxxxxxxx>]

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