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

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

pgsql-sql by date

Next:From: Igor KryltsovDate: 2004-11-19 05:57:01
Subject: SQL Question
Previous:From: Nick PetersDate: 2004-11-18 21:34:36
Subject: Re: Comparing Dates

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