Thank you for reply. The time return by SYSDATE depends on the OS timezone setting while in PostgreSQL we can set the timezone using 'set time zone..' statement so here timezone setting depends on DBMS but I think there are not so many systems that use different timezone settings between DBMS and OS. ----- Regards, Vinayak, -- View this message in context: http://postgresql.1045698.n5.nabble.com/Timezone-difference-between-Oracle-SYSDATE-and-PostgreSQL-timestamp-functions-tp5816851p5817107.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
