Home » RDBMS Server » Server Administration » Select systime with timezone
Select systime with timezone [message #199674] Wed, 25 October 2006 13:39
crosimoto
Messages: 6
Registered: June 2006
Location: Washington DC
Junior Member
how do I display the timezone information ie "CET"?
with the folowwing SQL statement

select to_char(current_timestamp,'MM/DD/YYYY HH24:MI:SS TZD'),
to_char(systimestamp, 'MM/DD/YYYY HH24:MI:SS TZD')
from dual;

TO_CHAR(CURRENT_TIMESTAMP, TO_CHAR(SYSTIMESTAMP,'MM/D
-------------------------- --------------------------
10/24/2006 14:30:48 10/24/2006 14:30:48

Thanks,
crosimoto

Previous Topic: Installing OMS
Next Topic: Help deciding on Local or Global Index
Goto Forum:
  


Current Time: Wed Dec 07 10:52:23 CST 2016

Total time taken to generate the page: 0.09981 seconds