trying to convert date format from dd-mon-yy into mm/dd/yyyy.
ex - input - 19-DEC-16 output should be - 12/19/16.
Please suggest
|
connection property: dateFormat dateFormat is used to specify a default parse sequence of date(Default: 'yyyy-MM-dd') format.
You can use 'dd-mmm-yy' to parse your input data.
If you wish to output 12/19/16, you can use
DTOS(date1 | timestamp1,pattern): returns a string according to a pattern format from a specified date or timestamp expression.
DOTOS(yourdata,'MM/DD/yy')
|