date versus datetime?

From: Eric McKeown <ericm(at)palaver(dot)net>
To: PGsql <pgsql-sql(at)postgreSQL(dot)org>
Subject: date versus datetime?
Date: 1998-08-01 02:59:00
Message-ID: Pine.LNX.3.96.980731215546.4018A-100000@toots.palaver.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi folks,

Would anyone have any recommendations for choosing the date type versus
the datetime type for storing date information? I think the date type is
probably sufficient for my needs, and it seems a bit simpler and handier;
for instance, it seems I can do this with the date type:

select * from table where date_field < some_date_I_specify_here

However, if my reading of the manual and my experiments are correct, I
can't perform that sort of operation with the datetime type. Is my
understanding correct?

Sorry for my newbie-ness...

eric

_______________________
Eric McKeown
ericm(at)palaver(dot)net
http://www.palaver.net

Browse pgsql-sql by date

  From Date Subject
Next Message Federico Passaro 1998-08-01 05:58:58 Re: [SQL] locked my keys in the car
Previous Message G.Elangovan 1998-08-01 00:15:17 Authentication Problems