Edit

Share via

NULLDATETIME ER function

  • Article

The NULLDATETIME function returns a DateTime value that represents the null date/time value (January 1, 1900) in Coordinated Universal Time (Greenwich Mean Time [GMT]).

Syntax

NULLDATETIME ()

Return values

DateTime

The resulting date/time value.

Example

DATETIMEFORMAT( NULLDATETIME(), "O") returns the string value 1900-01-01T00:00:00.0000000+00:00 when it's called during a process that was initiated by an application user who has the time zone value (GMT) Coordinated Universal Time in the Language and country/region preferences section.

Additional resources

Date and time functions