Any one know how to create a table where one of the column is of type datetime and default vaule is aggined as now() or someting like that so that every toime you insert any a new record to that table, the current date time value is automatically inserted as "MM/DD/YYYY HH:MMS".

use timestamp instead and then you can use date_format to retrive the info in whatever order you want.

see the Date_and_time_functions area in the manual for more info but here is an example:

say your timestamp column is timesold

SELECT date_format(timesold,'%m/%d/%y %h:%i:%s') as mytime FROM mytable;

I am looking for create table statement & how to define the default date entry in correct format. not a select statement.
-thanks

I don't think that MySQL can do that yet. Default values have to be constants, you can't use functions.

-PatP

patp does mysql

dbforums Message
You have included too many images in your signature or in your previous post. Please go back and correct the problem and then continue again.