Re: Comparing Dates

From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: PgSQL - SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Comparing Dates
Date: 2004-11-19 06:07:55
Message-ID: 5A709098-39F1-11D9-95C2-000D93AE0944@sitening.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Ha. Why so it is. :)

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Nov 18, 2004, at 11:50 PM, Greg Stark wrote:

> "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 Erik Thiele 2004-11-19 08:41:34 get sequence value of insert command
Previous Message Igor Kryltsov 2004-11-19 05:57:01 SQL Question