Postgresql date format with php

Question

I have a datetime field that saves data as a string. But I want to save it as a date type. Is there any date data type in Postgre sql that accepts this kind of date format? February 1, 2016, 10:17 AM

Default date-time format for Postgres is yyyy-mm-dd hh:mn:ss.ms. For example select '1812-10-23 11:12:13.111'::timestamp will be accepted everywhere. — Abelisto
– Abelisto, Commented Feb 1, 2016 at 3:16

Juan Carlos Oropeza · Accepted Answer · 2016-02-01 02:45:54Z

2

You can use TIMESTAMP, DATE or TIME field to save your date, but date variables/ fields in postgres doesnt save format.

http://www.postgresql.org/docs/9.4/static/datatype-datetime.html

You have to use postgres function to_date(text, text) to convert from string to date

http://www.postgresql.org/docs/9.4/static/functions-formatting.html

answered Feb 1, 2016 at 2:45

Juan Carlos Oropeza

48.4k14 gold badges87 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

barbarity · Accepted Answer · 2016-02-01 03:03:06Z

1

You have TIMESTRAMP and TIMESTAMP WITH TIME ZONE.

You can have all the information here: http://www.postgresql.org/docs/9.4/static/datatype-datetime.html

edited Feb 1, 2016 at 3:03

answered Feb 1, 2016 at 2:42

barbarity

2,5181 gold badge25 silver badges30 bronze badges

Collectives™ on Stack Overflow

Postgresql date format with php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest