DateTime Functions

Functions for working with combined date and time values.

DateTime.AddZone
Adds timezone offset information to a datetime value, returning a datetimezone.
DateTime.Date
Returns the date part from a datetime value.
DateTime.FixedLocalNow
Returns the current local date and time, fixed for the entire query evaluation.
DateTime.From
Converts a value to a datetime.
DateTime.FromFileTime
Converts a Windows file time (100-nanosecond intervals since 1601-01-01) to a datetime value.
DateTime.FromText
Converts a text representation of a datetime to a datetime value.
DateTime.IsInCurrentHour
Returns true if the datetime falls within the current hour.
DateTime.IsInCurrentMinute
Returns true if the datetime falls within the current minute.
DateTime.IsInCurrentSecond
Returns true if the datetime falls within the current second.
DateTime.IsInNextHour
Returns true if the datetime falls in the next clock hour.
DateTime.IsInNextMinute
Returns true if the datetime falls in the next clock minute.
DateTime.IsInNextNHours
Returns true if the datetime falls within the next N clock hours.
DateTime.IsInNextNMinutes
Returns true if the datetime falls within the next N clock minutes.
DateTime.IsInNextNSeconds
Returns true if the datetime falls within the next N seconds.
DateTime.IsInNextSecond
Returns true if the datetime falls in the next clock second.
DateTime.IsInPreviousHour
Returns true if the datetime falls in the previous clock hour.
DateTime.IsInPreviousMinute
Returns true if the datetime falls in the previous clock minute.
DateTime.IsInPreviousNHours
Returns true if the datetime falls within the previous N clock hours.
DateTime.IsInPreviousNMinutes
Returns true if the datetime falls within the previous N clock minutes.
DateTime.IsInPreviousNSeconds
Returns true if the datetime falls within the previous N seconds.
DateTime.IsInPreviousSecond
Returns true if the datetime falls in the previous clock second.
DateTime.LocalNow
Returns the current local date and time.
DateTime.Time
Returns the time part from a datetime value.
DateTime.ToRecord
Converts a datetime value to a record containing its parts.
DateTime.ToText
Converts a datetime value to a text string.
#datetime
Creates a datetime value from year, month, day, hour, minute, and second components.