SQL & PL/SQL

Hi All,

could someone please explain me what is the differnce between current_timestamp and systimestamp.

How to get current date and time in timestamp with time zone according to the internal clock of the local machine

I am trying to find differnce between two timestamps which are declared as timestamp with time zone as data type.

My database is in pacific time zone. I want to take local machine time to find the differnce.

If I say (database field timestamp - Current_timestamp ) than what time does the current_timestamp will take.


any help is highly appreciated.

thanks in advance