newbie wrote:The seconds answer (by user Chi) on this page explains this mystery: http://stackoverflow.com/questions/8884545/oracle-10g-time-zone-confusion
Is systimestamp and dbtimezone different? because i see systimestamp gives GMT -4:00 and dbtimezone gives +00:00.
Any clue why is this difference?
My thinking is systimestamp gives you the system(OS) level and dbtimezone gives you in db level.
Can you confirm this?