date conversion

deva · Post by **deva** » Thu May 29, 2008 11:14 am

Hi
I have one date field which is timestamp. its formate is mm/dd/yyyy hh:mm:ss.
I want to convert that time stamp to date as yyyymmdd or yyyy-mm-dd

Can any one suggest me on this.

chulett · Post by **chulett** » Thu May 29, 2008 11:28 am

If you always get two digit months and day, then you can substring it apart and put it back together however you please. Otherwise, standard IConv/OConv pairs will do the trick.

dsean · Post by **dsean** » Fri May 30, 2008 9:24 am

As Chulett said, you can use substr to get the date only from the input format that you have mentioned.

Else you can use built in transform TIMESTAMP.TO.DATE along with either OCONV function or DATE.TAG to get the date only from the timestamp.

Note : The input date format must be 'YYYY-MM-DD HH:MM:SS' to use TIMESTAMP.TO.DATE transform.