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
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 |