CODEWITHSUNDEEP
postgresqlgrails
asp_NewBee
asp_NewBee

Reputation: 299

Converting date into PostgreSQL format

I have a date time in format: Mon Jun 11 12:16:14 EDT 2013 I want it inserted in postgres as Date attribute, but postgres always inserts the current date time. I think it is the issue with the format. The normal date format in postgres is something like: 2012-06-13 04:24:45

How could I change Mon Jun 11 12:16:14 EDT 2013 format compatible to postgres?

Thank you!!!

Upvotes: 0

Views: 1366

Answers (1)

Chris Farmiloe
Chris Farmiloe

Reputation: 14185

You want the to_date or to_timestamp function.

You give it your string date, and a patten for how to parse the date. For your example it would be:

select to_timestamp('Mon Jun 11 12:16:14 EDT 2013', 'Dy Mon DD HH24:MI:SS ??? YYYY');

      to_timestamp      
------------------------
 2013-06-11 12:16:14+01

I don't think you can't work with the timezone with these functions unfortunately (hence the ???)

You should also just be able to cast the string like:

 'Mon Jun 11 12:16:14 EDT 2013'::timestamptz;

Upvotes: 1

Related Questions