Description
Converts a Date into a string.
Syntax
DateToString ( date, fmt )
Arguments
date is a date, and
fmt is a string identifying how to format the date.
Example
Converts a date to a formated string mm-dd-yy for all features where the country is Canada.
select DateToString(RANDOMDATE, 'mm-dd-yy') from countries where country='Canada'Remarks
For more information about the meaning of the fmt argument, see Date and Time Format Strings section.
Note: DateToString works with both Date and DateTime values.