Date-Time Functions

These functions are used to apply date-time operations on the row or grain of the data

  • Family: PQL
  • Library: Granular
  • Function List

    AddDays

    2023.00.000

    AddHours

    2023.00.000

    AddMinutes

    2023.00.000

    AddMonths

    2023.00.000

    AddQuarters

    2023.00.000

    AddWeeks

    2023.00.000

    AddYears

    2023.00.000

    Age

    2023.00.000

    Date

    2023.00.000

    DateDiff

    2023.00.000

    DateFormat

    2023.00.000

    DayNumber

    2023.00.000

    DayOfWeekName

    2023.13.000

    DayOfWeekNumber

    2023.13.000

    Hour

    2023.00.000

    Minute

    2023.00.000

    Month

    2023.00.000

    MonthName

    2023.00.000

    MonthNumber

    2023.00.000

    Now

    2023.00.000

    Quarter

    2023.00.000

    QuarterNumber

    2023.00.000

    Second

    2023.00.000

    ToDate

    2023.13.000

    Today

    2023.00.000

    Week

    2023.00.000

    WeekNumber

    2023.00.000

    Year

    2023.00.000