/wiki/spaces/DASSB100/pages/32569527069 Dates are one of the primitive data types used in Datameer. However, it is often necessary (during data imports and exports as well as when working with certain functions) to convert a date represented as a string to a form that is recognized as a date by Datameer. This is done by parsing the pattern so that it can be correctly interpreted. Use the table below to define the parse pattern.
...
Letter | Date or time component | Shown as | Example |
---|---|---|---|
G | Era designator | Text | AD |
C | Century of era | Number | 20 |
YWeek year | Year of era | Year | 1996 |
w | Week in year | Number | 27 |
e | Day in week | Number | 2 |
E, EE, or EEE - EEEE | Day of the week | Text | Tue - Tuesday |
y | Year | Year | 1996; 96 |
D | Day in year | Number | 189 |
MM - MMM; MMMM | Month of year | Month | 01 - Jan; January |
d | Day in month | Number | 10 |
a | Am/pm marker | Text | PM |
K | Hour in am/pm (0-11) | Number | 0 |
h | Hour in am/pm (1-12) | Number | 12 |
H | Hour in day (0-23) | Number | 0 |
k | Hour in day (1-24) | Number | 24 |
m | Minute in hour | Number | 30 |
s | Second in minute | Number | 55 |
S | Millisecond | Number | 978 |
x | Week's year | Number | 14 |
Examples
From string to date
...