Working with Date/Time Fields
Over the course of your data prep work, you may wish to convert text fields indicating dates and/or times into date/time fields. The following tables provides a list of text formats that are supported as date/time fields in Data Prep Studio:
|
General Format |
Text Format |
Date/Time Format |
|
Date |
Jan 17, 2015 |
1/17/2015 12:00:00 AM |
|
Date |
Jul 5 2016 |
7/5/2016 12:00:00 AM |
|
MMDDYY |
06.26.16 |
6/26/2016 12:00:00 AM |
|
MMDDYY |
06-06-15 |
6/6/2015 12:00:00 AM |
|
MMDDYY |
06/24/15 |
6/24/2015 12:00:00 AM |
|
MMDDYYYY |
11/20/2015 |
11/20/2015 12:00:00 AM |
|
DDMMYY |
06/06/16 |
6/6/2016 12:00:00 AM |
|
DDMMYYYY |
05/06/2016 |
5/6/2016 12:00:00 AM |
|
DDMMYY |
27.12.14 |
12/27/2014 12:00:00 AM |
|
DDMMYY |
25-09-16 |
9/25/2016 12:00:00 AM |
|
YYYYMMDD |
2015-10-07 |
10/7/2015 12:00:00 AM |
|
YYYYMMDD Time |
2014-11-01 22:58:42 |
11/1/2014 10:58:42 PM |
|
ISO 8601 |
2016-10-15T03:24:01-07:00 |
10/15/2016 10:24:01 AM |
|
Time 12 Hr |
12/31/1899 4:13:37 PM |
12/31/1899 4:13:37 PM |
|
Time 24 Hr |
12/31/1899 5:39:47 PM |
12/31/1899 5:39:47 PM |
|
Military Time |
600 |
600 |
|
Serial Date |
42161 |
6/8/2015 |
© 2024 Altair Engineering Inc. All Rights Reserved.