TODAY Function - Informix to SQL Server Migration

In Informix, the TODAY function returns the current date (year, month and day). In SQL Server, you can use CONVERT(DATE, GETDATE()) expression.

Informix:

  -- Get the current date
  SELECT TODAY 
  FROM systables WHERE tabid=1;
  /* 12/05/2024 */

SQL Server:

  -- Get the current date
  SELECT CONVERT(DATE, GETDATE())
  /* 2024-12-05 */

For more information, see Informix to SQL Server Migration.