Create PHP timestamp to insert into mysql databse [duplicate]

Question

How do I create this using PHP, for the current timestamp, ready to insert into a mysql database timestamp field:

2015-06-27 12:58:10

I want to insert a created_timestamp field basically...

I don't want to use the database's "on update current timestamp" feature because I want this to be a permanent fixed record.

Have you done any research or put any effort into your question? — Rizier123
– Rizier123, Commented Jun 27, 2015 at 13:04
@Rizier123 yes but I'm terrible with timestamps and such functions. — Amy Neville
– Amy Neville, Commented Jun 27, 2015 at 13:07
@AmyNeville But I think you know how to use google. So: PHP date <- That's it first php.net manual page and you got it all there. — Rizier123
– Rizier123, Commented Jun 27, 2015 at 13:10
@Rizier123 if I knew I was looking for the date function then yes... — Amy Neville
– Amy Neville, Commented Jun 27, 2015 at 13:22

Cohan · Accepted Answer · 2015-06-27 13:03:14Z

3

Use PHP's date() function

date("Y-m-d H:i:s")

answered Jun 27, 2015 at 13:03

Cohan

4,5942 gold badges25 silver badges40 bronze badges

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

1 Comment

Perfect thanks! I'll accept in 9mins