Andreas Karlsson <andr...@proxel.se> writes: > Hm, I am not sure if I see any major win from writing > date_trunc('day', timestamptz '2001-02-16 20:38:40+00', 'Australia/Sydney') > instead of > date_trunc('day', timestamptz '2001-02-16 20:38:40+00' AT TIME ZONE > 'Australia/Sydney')
The latter would give you timestamp without time zone, whereas I think what Vik wants is timestamp with time zone. Yeah, you could then convert it back with a second application of AT TIME ZONE 'Australia/Sydney', but that's both inefficient and mighty confusing. regards, tom lane