MySQL question

admin

Administrator
Staff member
I have the following situation: each time i insert a row into a table, i want the date of the operation to be inserted in a separated field(called process_date). I have set the process_date field to be a timestamp type, and its defalut value to be now(), but the date inserted into it is like 20010806231545. I need this date to be printed with separators, 2001-08-06 23:15:45 instead of 20010806231545. Could you help me with an answer here?Thanks
 
Back
Top