storage representation of DATE and TIME types

From: Dennis Gearon <gearond(at)fireserve(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: storage representation of DATE and TIME types
Date: 2004-10-05 16:23:18
Message-ID: 4162CA76.8070304@fireserve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

please cc me as I am on digetst:
--------------------------------

What is the storage format of 'date'? Is it like a timestamp?

I want to know in order to choose representations in a table that will
receive LOTS of reads with a WHERE clause that chooses dates, and TIMES,
past a supplied reference.

Browse pgsql-general by date

  From Date Subject
Next Message Reini Urban 2004-10-05 16:23:28 Re: postgresql 8.0 and tsearch2 install under cygwin
Previous Message D. Stimits 2004-10-05 16:21:43 Re: Random not so random