Re: Set mySQL table field by using NOW()

message from walfredo on 15 Jul 2004
Ok cool, that updated when I changed the column type to TIMESTAMP.
Thanks! Also, what would I set the default value to be if I wanted it
to format like 0000-00-00 00:00:00:00 As it stands, it only returns a
string like 20040715092204. Thanks!!
 
Michael Fesser replied to walfredo on 17 Jul 2004
.oO(walfredo)

Use the function DATE_FORMAT() when fetching the date from the db.

MySQL Manual | 13.5 Date and Time Functions
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html

HTH
Micha
 

Archived message: Re: Set mySQL table field by using NOW() (Macromedia Dreamweaver Web Design)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.