[postgis-users] data base structure for holding climate data

[Markus Schaber]

Hi, Guido,

Guido Lemoine wrote:
> Look at the (postgresql) timestamp data type, and check whether you
> require time zones to be defined. The format is generally 'YYYY-MM-DD
> hh:mm:ss' (plus time zone, if needed). It makes sense to use
> timestamp, so that you can use postgresql's date functions which are
> very useful. Combine very well with postgis functions.

I generally agree, with one little addition:

Use "Timestamp with timezone" (which has the shorter alias "timestamptz"
for lazy people). Using the one without time zone will only lead to trouble.

Read more at:
http://www.postgresql.org/docs/8.1/interactive/datatype-datetime.html

HTH,
Markus