appropriate column type to store day and time in YYYYMMDDhhmmss format

[Jason Joines]

	I'm using MySQL 4.1.7 and need to create a column to store date and 
time.  Also, I need to be able to update the column with something like:
update machines set update3_status='y', update3_time=SOMETHING;

	I don't want update3_time to be automatically changed any time another 
column changes.  What is the correct column type to use to get 
update3_time to contain day and time in the form YYYYMMDDhhmmss?  Is 
there a fuction or something to use in place of SOMETHING in the query?

Jason Joines
=================================
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]