Re: [SQL] Comparing Dates

[Guy Fraser]

You should use single quotes for all literals.
Examples:
select '2004-06-08' ;
 ?column?
------------
2004-06-08
select 'user' ;
?column?
----------
user
Failing to quote literals will cause unexpected results.
Examples:
select 2004-06-08 ;
?column?
----------
    1990
select user ;
current_user
--------------
guy
"Thomas F.O'Connell" <[EMAIL PROTECTED]> 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.


--
Guy Fraser
Network Administrator
The Internet Centre
780-450-6787 , 1-888-450-6787
There is a fine line between genius and lunacy, fear not, walk the
line with pride. Not all things will end up as you wanted, but you
will certainly discover things the meek and timid will miss out on.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faqs/FAQ.html