Vinayak wrote: > We have converted Oracle SYSDATE to PostgreSQL statement_timestamp() but > there is a difference in timezone. > SYSDATE returns the time on the server where the database instance is > running(returns operating system time) so the time depends on the OS > timezone setting. > while the timezone of postgreSQL > statement_timestamp()/now()/clock_timestamp() depends on the DBMS setting. > so I think timezone settings are different between DBMS and OS.
[...] > Any idea how can we set OS timezone on PostgreSQL? If you mean the *server's* OS timezone, I guess you'd have to write a C function that does something similar to identify_system_timezone() in bin/initdb/findtimezone.c. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
