On Sun, Jul 19, 2009 at 01:29:14PM -0700, Dennis Gearon wrote: > INSERTing timestampz, 'to_timestamp', output formatting, input formatting, SERVER TIME, USER_LOCAL_TIME, multi timezone applications. > > Anyone wonder how those all work? **I** sure do!!! The official docs[1,2] have generally been enough for me, could you be more specific about what is causing trouble? That said, I've never written code that needs to be more than trivially aware of timezones before. I'm not sure if this is just because the abstractions provided are nice or if I've not had to solve a hard problem here. > (3) Give input to me so that I can write a good tutorial to post on > the postgres site? There's already a page on the postgres wiki about this[3], maybe something needs clarifying? -- Sam http://samason.me.uk/ [1] http://www.postgresql.org/docs/current/static/datatype-datetime.html [2] http://www.postgresql.org/docs/current/static/functions-datetime.html [3] http://wiki.postgresql.org/wiki/Working_with_Dates_and_Times_in_PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
