On Mon, Aug 13, 2007 at 02:47:06PM +1000, Naz Gassiep wrote:
> When entering data into a timestamptz field, if no timezone is added
> does it assume you've entered a UTC time, or the time at the timezone
> set in the session with SET TIMEZONE, or the local system time ?
i dont understand - why didn't you simply test? instead of writing email
you could simply:
# select now();
now
-------------------------------
2007-08-13 07:13:54.363458+02
(1 row)
# select '2007-08-13 07:13:54'::timestamptz;
timestamptz
------------------------
2007-08-13 07:13:54+02
(1 row)
and everything is clear - it's local timezone.
depesz
--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
