MySQL server on Azure portal db cannot use default (current_date)

Question

When running

 creation_date date default (current_date),

getting error on MySQL server on Azure portal, but not on local MySQL workbench. How can we give the current date as default?

Answer 1

You can get current time by following sql querys:

  SELECT SYSDATETIME()

Select  SYSDATETIMEOFFSET ()

If you want to change to time zone you are living you can change it to local also, for further reference to change to local time refer this site.