Postgres Pro
Downloads
Home   >   mailing lists

Re: Dates/Timestamps in a where clause - Mailing list pgsql-general

From Einar Karttunen
Subject Re: Dates/Timestamps in a where clause
Date
Msg-id Pine.LNX.4.30.0102061611290.1818-100000@melkinpaasi.cs.Helsinki.FI
Whole thread Raw
In response to Dates/Timestamps in a where clause  ("Ian deSouza" <iandesouza@earthlink.net>)
List pgsql-general
Tree view 
On Thu, 1 Feb 2001, Ian deSouza wrote:
> Anybody know how to format a date/timestamp type in a where clause. ie.
>
> where OrderDate='1996-07-17 00:00:00.0'
>
You could try changing the datestyle before the query.
SET DATESTYLE ISO|SQL|Postgres|German ...
You can read more from
http://www.fr.postgresql.org/docs/postgres/sql-set.htm

- Einar Karttunen

pgsql-general by date:

Previous
From: "Adam Lang"
Date:
Subject: Re: Re: Write to postgreSQL via ODBC?
Next
From: James Thompson
Date:
Subject: Re: GUI Clients for PostgreSQL