Date Functions
A set of functions that help you deal with dates
format
Converts a date into a string using the specific format
Syntax
string = format(date, formatstring)
Example
date = Date("2020-10-22")
dstring = format(date, "ddMMMyyyy")
print dstring
22Oct2020
Notes on formatstring
| Letter | Date or Time Component | Presentation | Examples |
|---|---|---|---|
G | Era designator | Text | AD |
y | Year | Year | 1996 96 |
Y | Week year | Year | 2009 09 |
M | Month in year | Month | July Jul 07 |
w | Week in year | Number | 27 |
W | Week in month | Number | 2 |
D | Day in year | Number | 189 |
d | Day in month | Number | 10 |
F | Day of week in month | Number | 2 |
E | Day name in week | Text | Tuesday Tue |
u | Day number of week (1 = Monday, ..., 7 = Sunday) | Number | 1 |
a | Am/pm marker | Text | PM |
H | Hour in day (0-23) | Number | 0 |
k | Hour in day (1-24) | Number | 24 |
K | Hour in am/pm (0-11) | Number | 0 |
h | Hour in am/pm (1-12) | Number | 12 |
m | Minute in hour | Number | 30 |
s | Second in minute | Number | 55 |
S | Millisecond | Number | 978 |
z | Time zone | General time zone | Pacific Standard Time PST GMT-08:00 |
Z | Time zone | RFC 822 time zone | -0800 |
X | Time zone | ISO 8601 time zone | -08 -0800 -08:00 |
parse
Convert a string to a date
Syntax
date = parse(stringdate, formatstring)
Example
date = parse("22Oct2020", "ddMMMyyyy")
print date
2020-10-22T00:00:00
Notes on formatstring
| Letter | Date or Time Component | Presentation | Examples |
|---|---|---|---|
G | Era designator | Text | AD |
y | Year | Year | 1996 96 |
Y | Week year | Year | 2009 09 |
M | Month in year | Month | July Jul 07 |
w | Week in year | Number | 27 |
W | Week in month | Number | 2 |
D | Day in year | Number | 189 |
d | Day in month | Number | 10 |
F | Day of week in month | Number | 2 |
E | Day name in week | Text | Tuesday Tue |
u | Day number of week (1 = Monday, ..., 7 = Sunday) | Number | 1 |
a | Am/pm marker | Text | PM |
H | Hour in day (0-23) | Number | 0 |
k | Hour in day (1-24) | Number | 24 |
K | Hour in am/pm (0-11) | Number | 0 |
h | Hour in am/pm (1-12) | Number | 12 |
m | Minute in hour | Number | 30 |
s | Second in minute | Number | 55 |
S | Millisecond | Number | 978 |
z | Time zone | General time zone | Pacific Standard Time PST GMT-08:00 |
Z | Time zone | RFC 822 time zone | -0800 |
X | Time zone | ISO 8601 time zone | -08 -0800 -08:00 |
daylightSavings
Checks a day to see if it is a daylight savings changeover day.
Returns
- 0 if false
- -1 if it is the start day of DST
- 1 if it is the end day of DST
Syntax
result = daylightSavings(date, timezone)
Example
print daylightSavings(Date("2021-10-31"), "Europe/London")
1