ToString

Description

Convert datetime field to ISO-8601 string or a custom date time format.

Syntax

ToString(Datetime_field)

ToString(Datetime_field, formatString)

Arguments

  datetime_field - datetime expression. 

  formatString - output date time format pattern. For formatting information, see http://http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html.

Examples


ToString(ToDate('2013-10-17T00:00:00.000Z'),'MM-dd-yy') returns 10-17-13

Return value datatype

string

Impact of null value

If either parameter is null or not provided, returns null.

Feedback and Knowledge Base