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.

Intellectual Property Rights Notice | Technical Support