PHP date and time to Mysql datetime

Question

Im trying to get the current time in PHP using $sTime = date("Y-m-d H:i:s"); and store it in a mysql table in a datetime column like: $sTQuery = "INSERT INTO Actions(UserID, StartDuration) VALUES ('$UserID' , '$sTime')";

The date echos as expected but in the table it just shows 0000-00-00 00:00:0.

I have tried using now() in the query but still get 0000-00-00 00:00:0 in the table.

Edit: In the mysql table the column the date and time is to be stored in is a datetime

what's the column type or table schema? Also, read about PDO or at least about SQL Injection — Marcin Orlowski
– Marcin Orlowski, Commented Jan 31, 2018 at 11:43
if you use now(), make sure to use that without quotes. Although depending on the column type, you may need a different function like current_timestamp(). — GolezTrol
– GolezTrol, Commented Jan 31, 2018 at 11:44
Have you looked what has been stored in the database? This is not the same as a date 'print' or 'echo'. — KIKO Software
– KIKO Software, Commented Jan 31, 2018 at 11:45
Based on the code in your question (which is vulnerable to sql injection), this is not possible. The problem lies elsewhere in your code, but you are not providing enough information. Please edit your question with the create table statement, and the SELECT query you are testing with, so we can try to reproduce the problem. Also provide the result to SELECT NOW(). — rlanvin
– rlanvin, Commented Jan 31, 2018 at 11:57

A.D. · Accepted Answer · 2018-01-31 11:46:09Z

1

Try to use this query... This contains DateTime value by now() as per your need.

$sTQuery = "INSERT INTO Actions(UserID, StartDuration) VALUES ('$UserID' ,now())";

answered Jan 31, 2018 at 11:46

A.D.

2,3722 gold badges17 silver badges25 bronze badges

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

7 Comments

sammcd75 Over a year ago

Tried this and in the mysql table the entry is still 0000-00-00 00:00:00

A.D. Over a year ago

what? what your column data type.

sammcd75 Over a year ago

the column is a datetime

A.D. Over a year ago

so you tried the direct query on MySQL without PHP is this query give the same result there too?

A.D. Over a year ago

Make your column type as TIMESTAMP instead on DateTime may this can solve your issue.

|

Collectives™ on Stack Overflow

PHP date and time to Mysql datetime

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related