ToDate

ToDate Function

Converts a value to a date/time type.

Syntax

ToDate(scalar Value, scalar FormatString)

Arguments

Argument	Description
scalar Value	String date value
scalar FormatString	String format of the date value

Examples:

ToDate(37987.424, null)

Convert an OLE Automation date(represented as double).

ToDate('Jan 03, 2005', 'MMM, dd, yyyy')

Converts the date-time string using the specified format.