NumberToDateTime() function - MapBasic - 2023

Purpose

Returns a DateTime value. You can call this function from the MapBasic window in MapInfo Pro.

Syntax

NumberToDateTime( numeric_datetime ) 

numeric_datetime is an seventeen-digit integer in the form YYYYMMDDHHMMSSFFF. For example, 20140301214237582 represents March 1, 2014 9:42:37.582 PM.

Return Value

DateTime

Example

Copy this example into the MapBasic window for a demonstration of this function.

dim fNum as float
dim Y as datetime
fNum = 20140301214237582
Y = NumbertoDateTime (fNum)
Print FormatDate$(GetDate(Y))
Print FormatTime$(GetDate(Y),"hh:mm:ss.fff tt")

See also:

FormatTime$() function, GetTime() function, NumberToDate() function, NumberToTime() function