Postgres Pro
Downloads
Home   >   mailing lists

Re: Query with error - DOW FROM timestamp - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Query with error - DOW FROM timestamp
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17CFD9CB@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Query with error - DOW FROM timestamp  ("Victor Sterpu" <victor@caido.ro>)
Responses Re: Query with error - DOW FROM timestamp
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Victor Sterpu"
Date:
Subject: Query with error - DOW FROM timestamp
Next
From: Vincent de Phily
Date:
Subject: Downtime-free 'alter table set tablespace'