If you have date in below format,

10-FEB-13 02:10:09 i.e. dd-MMM-yy HH:mm:ss

then below code will be used,

from_unixtime(unix_timestamp(YOURDATE,’dd-MMM-yy HH:mm:ss’))

Advertisements