Syntax
ASDATE(<date string>;<optional data parse pattern>)
Description
Converts a character sequence to a date using either a predefined (dd-MM-yyyy hh:mm:ss, dd.MM.yyyy hh:mm:ss, dd-MM-yyyy, dd.MM.yyyy) or a custom date parse pattern.
For further details about date and time parse patterns please refer to Using Date and Time Patterns
Examples
Column1 | Date parse pattern | ASDATE returns |
|---|---|---|
19-01-2008 11:13:27 | dd-MM-yyyy hh:mm:ss | Sep, 19 2008 11:13:27 AM |
25.09.05 12:23:05 | dd.MM.yy hh:mm:ss | Sep, 25 2005 12:23:05 PM |
15-10-2002 | dd-MM-yyyy | Oct, 15 2002 12:00:00 AM |
06.11.2010 | dd.MM.yyyy | Nov, 25 2010 12:00:00 AM |
2011-05-04 | yyyy-MM-dd | May, 04 2011 12:00:00 AM |
| 2009-06-30T18:30:00.001 | yyyy-MM-dd'T'HH:mm:ss.SSS | Jun 30, 2009 06:30:00 PM |
Datameer X always uses the following format:
Three character month abbreviation (space) two digit day (comma)(space) four digit year (space) two digit hour (colon) two digit minute (colon) two digit second (space) two character meridiem notation.
(e.g., 12.01.2012 gets transferred to Jan 12, 2012 12:00:00 AM)
When selecting a pattern, you select the way the data gets parsed (your input format, this can be connected to your systems representation of dates and times).