User`s guide

uConvertDate
134 Sybase IQ ETL 4.1
Table 6-1: Date Conversion identifiers
Syntax string uConvertDate(datestring, inputformat [,
outputformat])
Parameters
string datestring
The string to convert.
string inputformat
The date and 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 To 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"
Identifier Description
Y Year 2-digits (06)
y Year 4-digits (2006)
C Century (20)
M Month (03)
m Month (JUN)
DDay (12)
H Hour (00..23)
h Hour (01..12)
NMinutes
S Seconds
s Hundreths of seconds
t Thousandth of seconds
AAM/PM
d Day of week (5)
D Day of week (Friday)
E Day of year (001..366)
G Week of year (01..52)
F Week of month (1..6)