Good Day:
--Query
SELECT SYSTIMESTAMP FROM DUAL;
--Output
16-JUL-14 09.31.36.781000000 AM +04:30
My SYSTIMESTAMP is in a TIMESTAMP_TZ format.
I always have to jump through hoops to extract hours and dates, meaning trying to get the info below:
--Desired Output
Date:
16-JUL-2014
Hour:
09:31 (24HH preferred)
What is the easiest way of extracting my desired output from SYSTIMESTAMP?
Thanks for all your help!
Aqua