Hiveql String to timestamp conversion

How to convert a date that is stored as string to a timestamp format.
I tried using CAST(date as timestamp),
unix_timestamp
from_unixtime(unix_timestamp)
nothing seems to be working for me