CURRENT_TIMESTAMP Function - SQL Server to PostgreSQL Migration

In SQL Server, the CURRENT_TIMESTAMP function returns the current date and time with milliseconds precision without time zone (it uses the server time zone).

In PostgreSQL, you can also use the CURRENT_TIMESTAMP function but it returns the current date and time with microseconds precision and includes the time zone.

SQL Server:

  -- Get the current date and time 
  SELECT CURRENT_TIMESTAMP;
  # 2024-10-22 21:55:27.067

PostgreSQL:

  -- Get the current date and time 
  SELECT CURRENT_TIMESTAMP;
  # 2024-10-22 21:55:27.067329+02

For more information, see SQL Server to PostgreSQL Migration.