Description
Converts a DateTime into a string.
Syntax
DateTimeToString ( datetime, fmt )
Arguments
datetime is a DateTime, and
fmt is a string identifying how to format the DateTime.
Example
Converts a datetime to a formatted string mm/dd/yyyy hh:mm:ss tt for all features where the country is Canada.
select DateTimeToString(RANDOMDATETIME, 'mm/dd/yyyy hh:mm:ss tt') from countries where country='Canada'Remarks
Refer to the section titled Date and Time Format Strings for more information on the meaning of the fmt argument.