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.
© 2024 Altair Engineering Inc. All Rights Reserved.