Function sqlDateTimeLiteral

  • Converts a javascript date into a format suitable for using in a LabKey SQL query, includes time but not milliseconds.

    Parameters

    • date: Date

      JavaScript Date

    • withMS: boolean

      include milliseconds

    Returns string

    a date and time literal formatted to be used in a LabKey query