Dremio Cloud
Dremio Software
 
On this page

    Categories: Date/Time

    LAST_DAY

    Returns the last day of the month for the specified date or timestamp.

    Syntax

    LAST_DAY(date_timestamp_expression string) → date

    • date_timestamp_expression: A DATE or TIMESTAMP expression.

    Examples

    LAST_DAY example 
    SELECT LAST_DAY('2009-01-12 12:58:59')
-- 2009-01-31
    LAST_DAY example 
    SELECT pickup_datetime, LAST_DAY(pickup_datetime) AS "last_day" 
FROM Samples."samples.dremio.com"."NYC-taxi-trips"
LIMIT 3

-- pickup_datetime, last_day
-- 2013-05-27 19:15:00.000, 2013-05-31
-- 2013-05-31 16:40:00.000, 2013-05-31
-- 2013-05-27 19:03:00.000, 2013-05-31

    Usage Notes

    The return value is always a date regardless of whether date_timestamp_expression is a date or a timestamp.