Re: Comparing Dates - Mailing list pgsql-sql

From Greg Stark
Subject Re: Comparing Dates
Date
Msg-id 87y8gy2xr1.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Comparing Dates  (Thomas F.O'Connell <tfo@sitening.com>)
Responses Re: Comparing Dates  (Thomas F.O'Connell <tfo@sitening.com>)
List pgsql-sql
"Thomas F.O'Connell" <tfo@sitening.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



pgsql-sql by date:

Previous
From: Nick Peters
Date:
Subject: Re: Comparing Dates
Next
From: Thomas F.O'Connell
Date:
Subject: Re: Comparing Dates