| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
