Hello
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-'));
Thank you
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-'));
Maybe you mean
SELECT EXTRACT(DOW FROM TO_TIMESTAMP('14-10-2011', 'DD-MM-'));
Yes, thank you.
-- Original Message --
From: "Albe Laurenz"
To: "Victor Sterpu" ; "PostgreSQL General"
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