Re: Unexpected parse behaviour for date to timestamp

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unexpected parse behaviour for date to timestamp
Date: 2003-03-07 16:58:03
Message-ID: 20030307085458.D92416-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed L. 2003-03-07 17:19:47 Re: replicating DDL statements
Previous Message Bruce Momjian 2003-03-07 16:40:07 Re: PgHosts