NULLDATETIME ER function
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
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for