If you use a date format your database understands and set the field type to timestamp then your date insert should work.

Databases differ in understanding dates, but should all be able to cope with ISO-SQL format: YYYY-MM-DD HH:MM:SS.sss (down to milliseconds). Some databases accept DEFAULT CURRENT_TIMESTAMP as a date column constraint so the database would insert the current time when the row is inserted