Table of Contents
Date/time parsing tokens are special combinations of letters you can use to read and extract date/time data. The following tables list the tokens you can use to parse data in your functionsFunctions you can use in Boost.space Integrator - create, update, delete, get, search.:
Input | Example | Description | |||
---|---|---|---|---|---|
YYYY |
2014 |
4 or 2 digit year | |||
YY |
14 |
2 digit year | |||
Y |
-25 |
Year with any number of digits and sign | |||
Q |
1..4 |
Quarter of year
|
|||
M MM |
1..12 |
Month number | |||
MMM MMMM |
Jan..December |
Month name | |||
D DD |
1..31 |
Day of month | |||
Do |
1st..31st |
Day of month with ordinal numbers | |||
DDD DDDD |
1..365 |
Day of year | |||
X |
1410715640.579 |
Unix timestamp | |||
x |
1410715640579 |
Unix ms timestamp |
Input | Example | Description |
---|---|---|
ddd dddd |
Mon...Sunday |
Day name |
GGGG |
2014 |
ISO 4 digit week year |
GG |
14 |
ISO 2 digit week year |
W WW |
1..53 |
ISO week of year |
E |
1..7 |
ISO day of week |
Input | Example | Description |
---|---|---|
H HH |
0..23 |
Hours (24 hour time) |
h hh |
1..12 |
Hours (12 hour time used with a A ) |
k kk |
1..24 |
Hours (24 hour time from 1 to 24) |
a A |
am pm |
Post or ante meridiem (Note the one character a p are also considered valid) |
m mm |
0..59 |
Minutes |
s ss |
0..59 |
Seconds |
S SS SSS |
0..999 |
Fractional seconds |
Z ZZ |
+12:00 |
Offset from UTC as +-HH:mm , +-HHmm , or Z |