The NOW() function returns the current date and time as `'YYYY-MM-DD HH:MM:SS', which can be directly stored in the DATETIME field.
CURDATE() returns today’s date in the format of ‘YYYY-MM-DD’, which can be directly stored in the DATE field.
CURTIME() returns the current time in the format of 'HH:MM:SS', which can be directly stored in the TIME field.
Example: insert into tablename (fieldname) values (now())