Get current date and time.

[GrayFox12]

Hi guys, im trying to get the current date and time to add to my mysql database.

 

At the moment im doing it something like this:

 

$date = date("d,m,y");

$time = time("g,i,a");

 

 

But i get completely random dates and times.  Some of the dates come out as year 2010.  How do i get it so i get the current date and time off the workstation or the server?

[trq]

You can't get a clients time with php, only server time. The code you have seems fine are you sure you want the values comma seperated though?

[GrayFox12]

sorry their slash in their instead of comma. cant remember wat i put. So it could be server?

[unkwntech]

With $date = date("d,m,y"); you should get the server date somthing like 17,07,08 however if you are getting values other then what is correct then there is a problem with the time at the server.

[PFMaBiSmAd]

date("d,m,y") is not a mysql DATE or DATETIME format and attempting to put that into a DATE or DATETIME field will only work on rare occasions where the values in the fields happen to correspond to a real DATE or DATETIME value.

 

time("g,i,a") is meaningless, because the time() function does not accept any parameters. You would either get an error or it would function, giving you a Unix Timestamp.

 

To get the current server datetime, use the mysql NOW() function directly in your query.

[j007ha]

try this :

 

echo date('d-m-y h:i:s', time());

 

hope this can help

[kenrbnsn]

You don't need a second parameter to the date() function if you want the current date/time.

 

This:

<?php
echo date('Y-m-d h:i:s');
?>

 

will work just fine.

 

Ken