Re: Unexpected parse behaviour for date to timestamp - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Unexpected parse behaviour for date to timestamp
Date
Msg-id 20030307085458.D92416-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Unexpected parse behaviour for date to timestamp conversion  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
Responses Re: Unexpected parse behaviour for date to timestamp  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Sat, 8 Mar 2003, Jean-Christian Imbeault wrote:

> I have this field:
>
> submit   | timestamp(0) without time zone
>
>
> The following two SQL queries return different values depending on
> wether the date is quoted or not ...
>
> I am assuming it is because the date is being parsed differently.
>
> # select submit from invoices where submit <= 2003-03-09;

The right side isn't a date.  It's an integral expression that evaluates
to 1991 I believe.


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: PgHosts
Next
From: "Ed L."
Date:
Subject: Re: replicating DDL statements