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.