On this page

    Categories: Date/Time

    EXTRACT

    Extracts the specified date or time part from the date or timestamp.

    Syntax

    EXTRACT(time_unit KEYWORD, date_time_expression DATE, TIME, TIMESTAMP) → INTEGER

    • time_unit: The time unit that needs to be extracted from the date, time or timestamp. This must YEAR, MONTH, DAY, HOUR, MINUTE, or SECOND.
    • date_time_expression: The date, time or timestamp to extract time part from.

    Examples

    SELECT EXTRACT(HOUR FROM CAST('05:33:44' AS TIME))
    -- 5
    
    SELECT EXTRACT(MONTH FROM CAST('2021-03-22 05:33:44.2' AS TIMESTAMP))
    -- 3
    
    SELECT EXTRACT(SECOND FROM CAST('2021-03-22 05:33:44.2' AS TIMESTAMP))
    -- 44
    
    SELECT EXTRACT(YEAR FROM CAST('2021-03-22' AS DATE))
    -- 2021