Hi,
I am looking at multitime zone env.
Please let me know if I can run the below command against progress db and display to the user his/her local date and time.
SELECT localtimestamp from dual
If not what alternate solution do I have.
Thanks,
I am looking at multitime zone env.
In Oracle/PLSQL, the localtimestamp function returns the current date and time in the time zone of the current SQL session as set by the ALTER SESSION command. It returns a TIMESTAMP value.10-Sep-05 10.58.24 PM
Please let me know if I can run the below command against progress db and display to the user his/her local date and time.
SELECT localtimestamp from dual
If not what alternate solution do I have.
Thanks,