PHP - Inserting date into datetime field

Question

I have used a datetime field in my database for storing dates, whats the proper way to insert say todays date into that field using PHP?

Cheers,

Do you want to know for an arbitrary date? Because for today I would use MySQL's NOW() function (assuming you use MySQL, I'm pretty sure other DBMS' offer the same). — Felix Kling
– Felix Kling, Commented Mar 6, 2011 at 9:37

Pekka · Accepted Answer · 2011-03-06 09:35:14Z

3

Don't use PHP at all, but the database's built-in function for that.

Assuming you're using mySQL, the function's name is NOW().

11.7. Date and Time functions in the mySQL manual

answered Mar 6, 2011 at 9:35

Pekka

451k150 gold badges990 silver badges1.1k bronze badges

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

Comments

Muhamad Bhaa Asfour · Accepted Answer · 2011-03-06 09:35:15Z

2

i think you can use the php date() function

answered Mar 6, 2011 at 9:35

Muhamad Bhaa Asfour

1,0353 gold badges22 silver badges40 bronze badges

Comments

Robus · Accepted Answer · 2011-03-06 09:37:15Z

1

INSERT INTO table (`date`)VALUES (NOW());

answered Mar 6, 2011 at 9:37

Robus

8,2895 gold badges52 silver badges70 bronze badges

Comments

Ivar · Accepted Answer · 2011-03-06 09:39:07Z

0

Use the PHP function time() instead and store the value as a normal integer - that gives you much more possibilities.

answered Mar 6, 2011 at 9:39

Ivar

4,4026 gold badges41 silver badges54 bronze badges

Comments

Logan Bibby · Accepted Answer · 2011-03-06 09:45:12Z

0

As everyone else has said, using the MySQL function NOW() would probably be the best bet for a DATETIME column. MySQL also has many date and time functions available.

Personally, I do what Ivarska suggested and use an INT data type with PHP's time() or MySQL's UNIX_TIMESTAMP(). It gives the date in the GMT standard and it will port over easily.

answered Mar 6, 2011 at 9:45

Logan Bibby

1,1971 gold badge11 silver badges33 bronze badges

Collectives™ on Stack Overflow

PHP - Inserting date into datetime field

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related