Re: Dates/Timestamps in a where clause

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