Casting 9/18/2013 6:08:46 AM , 9/9/2013 6:08:46 AM into TIMESTAMP(3) format

Analytics

Casting 9/18/2013 6:08:46 AM , 9/9/2013 6:08:46 AM into TIMESTAMP(3) format

Hi  ,

We need to cast these following timestamps in to TIMESTAMP(3) Format.

9/18/2013 6:08:46 AM


9/9/2013 6:08:46 AM

 

we are recieving these from the source.

We dont want to extract day , and month part and padd zeroes in case less than 10.

Is there any other sollution then this ?

 

Please help.