Re: Comparing Dates

From: Greg Stark <gsstark(at)mit(dot)edu>
To: "Thomas F(dot)O'Connell" <tfo(at)sitening(dot)com>
Cc: Nick Peters <nick(dot)peters(at)candoltd(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Comparing Dates
Date: 2004-11-19 05:50:26
Message-ID: 87y8gy2xr1.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


"Thomas F.O'Connell" <tfo(at)sitening(dot)com> writes:

> select 2004-06-08;
> ?column?
> ----------
> 1990
>
> I'm not exactly sure how the bare string is converted internally, but it's
> clearly not a complete date like you're expecting.

What string? That's just integer arithmetic.

--
greg

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Igor Kryltsov 2004-11-19 05:57:01 SQL Question
Previous Message Nick Peters 2004-11-18 21:34:36 Re: Comparing Dates