Re: Query with error - DOW FROM timestamp

Yes, thank you.

------ Original Message ------
From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Victor Sterpu" <victor(at)caido(dot)ro>; "PostgreSQL General"
<pgsql-general(at)postgresql(dot)org>
Sent: 5/23/2014 12:51:30 PM
Subject: RE: [GENERAL] Query with error - DOW FROM timestamp

>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