Re: Dates/Timestamps in a where clause

From: Einar Karttunen <ekarttun(at)cs(dot)Helsinki(dot)FI>
To: Ian deSouza <iandesouza(at)earthlink(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Dates/Timestamps in a where clause
Date: 2001-02-06 14:15:52
Message-ID: Pine.LNX.4.30.0102061611290.1818-100000@melkinpaasi.cs.Helsinki.FI
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adam Lang 2001-02-06 14:21:45 Re: Re: Write to postgreSQL via ODBC?
Previous Message Fernando del Valle 2001-02-06 14:11:39 Attribute inhrel not found