PostgreSQL: Cast a String to Timestamp in PostgreSQL

Published 20 Aug 2008. Show Comments.
Tags: programming postgres database snippet

If storing a date/timestamp in a varchar or text field in postgres, the to_timestamp() function will let you access the value as a 'real' date. The second parameter tells the function the format of your string:

SELECT to_timestamp('2008-08-01', 'YYYY-MM-DD') AS date;

« Previous Post

avatar

Chris Blunt

Plymouth Software

Devon, England

twitter.com/cblunt

github.com/cblunt

 

facebook.com/cbluntuk

flickr.com/photos/cblunt