79088807

Date: 2024-10-15 07:28:09
Score: 2.5
Natty:
Report link

CURRENT_TIME does not return a DATETIME

https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html#function_curtime

What you are probably after is TIMESTAMP instead, something like this:

created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html#function_now

Reasons:
  • Probably link only (1):
  • Low length (1):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Rairot