Different time in different sessions I am connecting to same db from 2 different machines using SQL Developer and querying a table which stores timestamp.
But to my surpise the time value returned by query has a gap of one hour on different machine. How is this possible as we are conencting to same DB? and whats the solution.
Probably different timezone is configured on those machines. Check:

SELECT SESSIONTIMEZONE FROM dual;