uConvertDate

The function handles dates from 1582 to present day. If the date cannot be converted, the result string is empty.

Syntax

string uConvertDate(datestring, inputformat [, outputformat])

Parameters

• string datestring – The date string to convert
• string inputformat – The date/time format of the input string
• string outputformat (optional) – The desired output format. If omitted, the default format is y-M-D H:N:S.

Examples

• Example 1 – Convert date strings into a different formats:

  uConvertDate("2005-06-27 00:00:00","y-M-D H:N:S","D mY") // returns "27 JUN 05"

  uConvertDate("27 JUN 05", "D m Y") // returns "2005-06-27 00:00:00"

  Sybase recommends you to provide input data for all the fields required in the output data. Having fields in the output data for which no input data has been provided, can lead to unexpected results. For example, if you require hours, minutes, and seconds fields in the output data, your input data should be something similar to this:

  uConvertDate("27 JUN 05", "D m Y", "y-m-D 00:00:00") // returns "2005-06-27 00:00:00" 

Usage

The function uConvertDate converts a date string into a different format using a source and a destination format string. The first parameter is the date string to be converted. The second parameter is a format string, specifying the date format of the input date (see list below). The outputformat parameter is optional; If omitted the date is converted using the format y-M-D H:N:S. The function handles dates from 1582 to present day. If the date cannot be converted, the result string is empty.