Current Time and date

[nclocl]

I'm looking to enter the current time and date into a mysql database using php.  My current code looks like this:

 

$now = date("m/d/y",time());

 

I then insert $now into the table into a datetime column.  This all works but the time when read from the column appears as 0000-00-00 00:00:00.

 

Any ideas what I'm doing wrong?

 

Thanks in advance.

[JasonLewis]

You can simply use the NOW() function in MySQL for this kind of thing.

 

INSERT INTO users (name, date) VALUES ('Jaysonic', NOW())

[nclocl]

perfect, thank you

 

Is there any way to tell it what timezone I'm in or is that related to the mysql server?

[JasonLewis]

It's determined by the server, but you can specify a timezone for MySQL to run in to make things run a little smoother. Or you can handle timezones directly in PHP.

Check out the documentation on timezones for MySQL. I personally hate dealing with timezones, it makes things so complicated some times. Well, it makes them seem more complicated then they should.