Formats a datetime, date or time
TimeFormat(date=[any], mask=[string], timezone=[string], locale=[string])
Argument | Type | Required | Description | Default |
---|---|---|---|---|
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 |
false |
Optional ISO locale string which will be used to localize the resulting date/time string |
- ClearTimezone
- CreateDate
- CreateDateTime
- CreateODBCDate
- CreateODBCDateTime
- CreateODBCTime
- CreateTimeSpan
- DateAdd
- DateCompare
- DateConvert
- DateDiff
- DateFormat
- DatePart
- DateTimeFormat
- 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
- Week
- Year