handling dates

[Toe]

I want to store a date in a mysql database and access this via PHP.

Is there a built in type for this (in mysql) and does php have supporting functions for their manipulation

 

[sleipnir214]

MySQL's date and time column types:

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

PHP's date and time functions:

http://us4.php.net/manual/en/ref.datetime.php

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[hos2]

and if you just need the date the record is last updated you can use timestamp in mysql. it is automaticly filled when adding a record. and it's updated when the record is updated