Insert the current time into the MySQL database datetime type field

Code:

            StringBuilderSB =NewStringBuilder (); Sb.append ("INSERT INTO Uosdetailfile ("); Sb.append ("FileName,"); Sb.append ("Content,"); Sb.append ("Addtime"); Sb.append (") VALUES ("); Sb.append ("' {0} ',"); Sb.append ("' {1} ',"); Sb.append ("Now ()"); Sb.append ("    )"); String result=sb.tostring (); Object[] Arr={filename, content}; String SQL=Messageformat.format (result, arr); intCount = statement.executeupdate (SQL);

The now function in the above code is to insert the current time into the Addtime field.

The functions for the current time and date in MySQL are:

The now () function returns the current datetime with ' Yyyy-mm-dd HH:MM:SS ' and can be stored directly in the DateTime field.
Curdate () returns today's date in the format ' Yyyy-mm-dd ', which can be stored directly in the Date field.
Curtime () returns the current time in the format ' HH:MM:SS ', which can be stored directly in the Date field.

Insert the current time into the MySQL database datetime type field