changing CURRENT_TIMESTAMP format

[tomasd]

Hi,

I've got a table;

+------------+--------------+------+-----+-------------------+-------+
| Field      | Type         | Null | Key | Default           | Extra |
+------------+--------------+------+-----+-------------------+-------+
| check_date | timestamp    | NO   |     | CURRENT_TIMESTAMP |       |
| out_date   | date         | NO   |     |                   |       |
| out_time   | time         | NO   |     |                   |       |
| price      | decimal(5,2) | YES  |     | NULL              |       |
+------------+--------------+------+-----+-------------------+-------+

 

check_date field is set to insert timestamp on update, is there anyway of changin CURRENT_TIMESTAMP format from 2007-12-20 11:38:21 to 2007-12-20? (just the date)

 

Any help is much appreciated!

[fenway]

You want TIMESTAMP not to have a time? Why?  Who cares? Let it be there, you can always remove it for output... why would you throw away valuable data?