insert date in postgres database

Question

I have a day, month and year in php variables. How can I use them in a SQL INSERT statement, knowing that the field I want to insert that date is of the date type.

Thanks.

Just for reference - a list of recognised DATE formats.

Milen A. Radev
– Milen A. Radev

2011-04-19 08:45:01 +00:00
Commented Apr 19, 2011 at 8:45 — Milen A. Radev
– Milen A. Radev, Commented Apr 19, 2011 at 8:45

Nafiu Lawal · Accepted Answer · 2020-01-21 15:49:37Z

1

Just format the date as a string and pass it to the SQL query

   $date =  sprintf("%04d-%02d-%02d",$year,$month,$day)

where you can replace the $year, $month and $day variables with your desired input.

edited Jan 21, 2020 at 15:49

Nafiu Lawal

4761 gold badge7 silver badges17 bronze badges

answered Apr 18, 2011 at 17:50

leonbloy

76.4k22 gold badges149 silver badges197 bronze badges

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

Comments

yogsma · Accepted Answer · 2011-04-18 17:52:39Z

0

Try PHP's date() method and then possibly combine with strtotime() to convert to right format.

answered Apr 18, 2011 at 17:52

yogsma

10.7k32 gold badges108 silver badges158 bronze badges

Collectives™ on Stack Overflow

insert date in postgres database

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

Related