SQL Eval Function DateTime_ToLocalTime

DateTime_ToLocalTime converts the value of the currDate DateTime object to local time.

DateTime_ToLocalTime (
	@currDate DATETIME
	)
RETURNS BIGINT

Parameters

  • currDate: The current datetime object.

Returns

A DateTime object in local time equivalent to the value of the current DateTime object, or MaxValue if the converted value is too large to be represented by a DateTime object, or MinValue if the converted value is too small to be represented as a DateTime object.

Example

SELECT SQLNET::DateTime_ToLocalTime('2015-5-25')

Contents