Best format to save date?

[eluser]bcorcoran[/eluser]
[quote author="modelreject" date="1241478438"]This is what I am using at the moment. Do you see any issues that could arise in the future...

$now = date("Y-m-d H:i");

Many thanks for the responses so far.[/quote]

Personally, in addition to one of the replies above, I store the output of time() in an INT(11) field for flexibility. time() outputs a unix timestamp which is very well established.

I output dates in any format I want, e.g.

Code:

<?php echo date("Y-m-d H:i:s", $query->timestamp); ?>

I dont necessarily use the variable "$query->timestamp", that's just to show you where that value goes in the date() function.

Hope this helps.