SQL Eval Function DateTime_ToLongTimeString

DateTime_ToLongTimeString converts the value of the current DateTime object to its equivalent long time string representation.

DateTime_ToLongTimeString (
	@currDate DATETIME
	)
RETURNS NVARCHAR (MAX)

Parameters

  • currDate: The current datetime object.

Returns

A string that contains the long time string representation of the current DateTime object.

Example

SELECT SQLNET::DateTime_ToLongTimeString('2015-5-25 3:02:15 AM')

Contents