Postgres Pro
Downloads
Home   >   mailing lists

storage representation of DATE and TIME types - Mailing list pgsql-general

From Dennis Gearon
Subject storage representation of DATE and TIME types
Date
Msg-id 4162CA76.8070304@fireserve.net
Whole thread Raw
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: looking for Mac pgEdit beta testers
Next
From: "Johann Robette"
Date:
Subject: Postgres 8.0 + JDBC