MySQL TimeStamp

Posted: Sat Jan 25, 2003 2:09 pm (21 years, 2 months ago)

Hi, I want to get the current time as a mySQL timestamp from my database. What command should I use?

mysql> SELECT now();

only gives it in the wrong format Sad

e.g 2000-08-03 16:56:03

thanks,

Team Member Joined: 06 Jan 2002 Posts: 2564

I'm just curious, why would you want to SELECT the current time from your database, as opposed to just getting it from PHP?

Posted: Sat Jan 25, 2003 2:23 pm (21 years, 2 months ago)

Daniel wrote:

I'm just curious, why would you want to SELECT the current time from your database, as opposed to just getting it from PHP?

Because the time on the DB is different to that in PHP because they are on different servers.
I have just worked out a better way to do this so it doesn't matter now.

Thanks,

Team Member Joined: 06 Jan 2002 Posts: 2564

For those interested, you could probably have used the DATE_FORMAT(NOW(),'FORMAT') function. For details, visit http://www.mysql.com/doc/en/Date_and_time_functions.html.