DateTime.From
DateTime.From(value as any, optional culture as nullable text) as nullable datetime
Returns a datetime
value from the given value
. An optional culture
may also be provided (for example, "en-US"). If the given value
is null
, DateTime.From returns null
. If the given value
is datetime
, value
is returned. Values of the following types can be converted to a datetime
value:
text
: Adatetime
value from textual representation. Refer to DateTime.FromText for details.date
: Adatetime
withvalue
as the date component and12:00:00 AM
as the time component.datetimezone
: The localdatetime
equivalent ofvalue
.time
: Adatetime
with the date equivalent of the OLE Automation Date of0
as the date component andvalue
as the time component.number
: Adatetime
equivalent of the OLE Automation Date expressed byvalue
.
If value
is of any other type, an error is returned.
Convert #time(06, 45, 12)
to a datetime
value.
Usage
DateTime.From(#time(06, 45, 12))
Output
#datetime(1899, 12, 30, 06, 45, 12)
Convert #date(1975, 4, 4)
to a datetime
value.
Usage
DateTime.From(#date(1975, 4, 4))
Output
#datetime(1975, 4, 4, 0, 0, 0)