000001 > SELECT extract(MONTHS FROM INTERVAL '2-11' YEAR TO MONTH); 11 > SELECT extract(SECONDS FROM INTERVAL '5:00:30.001' HOUR TO SECOND); 30.001000 Related functions date_part function dayname function dayofweek function dayofmonth function dayofyear function...
Extracting the date and time independently from a timestamp is also very easy: Use Date and Time Functions in SQL Query to Extract Date and Time from Timestamp DATE (current timestamp) TIME (current timestamp) Related Posts