Samples for Timestamp Functions

 


SELECT
EXTRACT(year FROM CURRENT_TIMESTAMP) EY,
EXTRACT(month FROM CURRENT_TIMESTAMP) EM,
EXTRACT(day FROM CURRENT_TIMESTAMP) ED,
EXTRACT(hour FROM CURRENT_TIMESTAMP) EH,
EXTRACT(minute FROM CURRENT_TIMESTAMP) EM,
EXTRACT(second FROM CURRENT_TIMESTAMP) ES,
EXTRACT(timezone_hour FROM CURRENT_TIMESTAMP) TH,
EXTRACT(timezone_minute FROM CURRENT_TIMESTAMP) TM,
EXTRACT(timezone_region FROM CURRENT_TIMESTAMP) TR,
EXTRACT(timezone_abbr FROM CURRENT_TIMESTAMP) TA
FROM DUAL;