All pages
Powered by GitBook
1 of 1

Loading...

DateTimeFormat

Formats a datetime, date or time

Method Signature

Arguments

Argument
Type
Required
Description
Default

Examples

Omitting the Mask

Should default mask to hh:mm tt

Result: 03:25 pm

Additional Examples

Related

DateTimeFormat(date=[any], mask=[string], timezone=[string], locale=[string])

Optional ISO locale string which will be used to localize the resulting date/time string

CreateODBCDateTime
  • CreateODBCTime

  • CreateTime

  • CreateTimeSpan

  • DateAdd

  • DateCompare

  • DateConvert

  • DateDiff

  • DateFormat

  • DatePart

  • Day

  • DayOfWeek

  • DayOfWeekAsString

  • DayOfWeekShortAsString

  • DayOfYear

  • DaysInMonth

  • DaysInYear

  • FirstDayOfMonth

  • GetNumericDate

  • GetTime

  • GetTimezone

  • GetTimezoneInfo

  • Hour

  • Millisecond

  • Minute

  • Month

  • MonthAsString

  • MonthShortAsString

  • Nanosecond

  • Now

  • Offset

  • ParseDateTime

  • Quarter

  • Second

  • SetTimezone

  • TimeFormat

  • TimeUnits

  • Week

  • Year

  • date

    any

    true

    The date string or object

    mask

    string

    false

    Optional format mask, or common mask. If an explicit mask is used, it should use the mask characters specified in the java.time.format.DateTimeFormatter class. If a common mask is used, the following are supported: - short: equivalent to "M/d/y h:mm tt" - medium: equivalent to "MMM d, yyyy h:mm:ss tt" - long: medium followed by three-letter time zone; i.e. "MMMM d, yyyy h:mm:ss tt zzz" - full: equivalent to "dddd, MMMM d, yyyy H:mm:ss tt zz" - ISO8601/ISO: equivalent to "yyyy-MM-dd'T'HH:mm:ssXXX" - epoch: Total seconds of a given date (Example:1567517664) - epochms: Total milliseconds of a given date (Example:1567517664000)

    timezone

    string

    false

    Optional specific timezone to apply to the date ( if not present in the date string )

    locale

    string

    Run Example
    ClearTimezone
    CreateDate
    CreateDateTime
    CreateODBCDate

    false

    timeFormat( createDateTime( 2017, 8, 31, 15, 25, 11 ) );