GETDATE Function - SQL Server to MySQL Migration

In SQL Server the GETDATE function returns the current date and time with milliseconds precision without the time zone for the current database instance.

In MySQL you can use the NOW(3) function.

SQL Server:

  -- Get the current date and time with milliseconds precision
  SELECT GETDATE();
  # 2024-07-28 13:13:11.640

MySQL:

  -- Get the current date and time with milliseconds precision
  SELECT NOW(3);
  # 2024-07-28 13:13:11.640

For more information, see SQL Server to MySQL Migration.