db and time

[JakesSA]

whats the best way to store time in the database (timestamp) and then to display it into a user friendly fasion.

Ive been having problems, with getting the db timestamp working with the date() on a NT box.

[cgraz]

if you're using mysql, just use NOW()

INSERT INTO table (date_field) VALUES(NOW());

Then to display, use DATE_FORMAT()

SELECT DATE_FORMAT(date_field, '%y-%m-%d') AS date FROM table;

http://www.mysql.com/doc/en/Date_and_time_functions.html

Search that page for DATE_FORMAT

Cgraz