Number to Date/Time

Description

Converts a number to a date/time format.

Monarch Data Prep Studio converts numbers to dates by considering the numeric value as the number of days (and fractions of days) since a specific "zero" date/time.

Monarch Data Prep Studio uses 1900-01-01 00:00:00 as its "zero" date/time. Thus:

 

This Number

Is Converted as

0.0

1900-01-01 00:00:00

0.25

1900-01-01 06:00:00

0.5

1900-01-01 12:00:00

1.0

1900-01-02 00:00:00

 

Refer to Notes on Conversions for more details on how Monarch Data Prep Studio converts number to date/time.

Input/Output Data Type

Input

Output

number

date/time

 

Example

In this example, Number is the original column and Number to Date/Time shows the converted values.

 

(c) 2023 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support