Cast date to timestamp in pgSQL

Viewed 45605

Is there a way to cast a date to timestamp. For an example if I had a date like 2012/05/01, how can I convert it to a timestamp like 2012-05-01 00:00:01

4 Answers
Related