Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

Next:From: Erik ThieleDate: 2004-11-19 08:41:34
Subject: get sequence value of insert command
Previous:From: Igor KryltsovDate: 2004-11-19 05:57:01
Subject: SQL Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group