README.md

Table of Contents

• Microsoft SQL Server compatibility
  • CONVERT_TO_CHAR
  • CONVERT_TO_DATE
  • DATEADD
  • DATEDIFF
  • DATENAME
  • DATEPART
  • EOMONTH
  • GETUTCDATE
  • NEWID
  • PATINDEX
  • JSON_VALUE
  • ISJSON

Microsoft SQL Server compatibility

CONVERT_TO_CHAR

convert_date_to_char.sql

This function is a partial compatibility implementation of MS SQL Server's CONVERT function. It converts a date to a string using the specified style.

CONVERT_TO_CHAR(p_expr IN TIMESTAMP, p_style IN NUMBER ) RETURN VARCHAR(50)

CONVERT_TO_DATE

convert_to_date.sql

This function is a partial compatibility implementation of MS SQL Server's CONVERT function. It converts a string to a date using the specified style.

CONVERT_TO_DATE(date_expression VARCHAR(200), style NUMBER ) RETURN DATE

DATEADD

dateadd.sql

This function is a compatibility implementation of MS SQL Server's DATEADD function. It adds a specified interval value (as a signed integer) to a specified datepart of an input date expression value, and then returns that modified value.

DATEADD(datepart VARCHAR(11), interval_value NUMBER, date_expression TIMESTAMP) RETURN TIMESTAMP

DATEDIFF

datediff.sql

This function is a compatibility implementation of MS SQL Server's DATEDIFF function. It returns the count (as a signed integer value) of the specified datepart boundaries crossed between the specified startdate and enddate.

DATEDIFF(datepart VARCHAR(11), startdate TIMESTAMP, enddate TIMESTAMP) RETURN NUMBER

DATENAME

datename.sql

This function is a compatibility implementation of MS SQL Server's DATENAME function. It returns a character string representing the specified datepart of the specified date.

DATENAME(datepart VARCHAR(11), date_expression TIMESTAMP ) RETURN VARCHAR(30)

DATEPART

datepart.sql

This function is a compatibility implementation of MS SQL Server's DATEPART function. It returns an integer representing the specified datepart of the specified date.

DATEPART(datepart VARCHAR(11), date_expression TIMESTAMP) RETURN NUMBER

EOMONTH

eomonth.sql

This function is a compatibility implementation of MS SQL Server's EOMONTH function. It returns the last day of the month given.

EOMONTH(date_in IN TIMESTAMP) RETURN DATE

GETUTCDATE

getutcdate.sql

This function is a compatibility implementation of MS SQL Server's GETUTCDATE function. It returns the current database system timestamp in the UTC (Coordinated Universal Time) time zone.

GETUTCDATE()

NEWID

newid.sql

This function is a compatibility implementation of MS SQL Server's NEWID function. It returns a version 4 UUID/GUID (a uniqueidentifier equivalent).

Note: As Exasol does not currently support UUID/GUID data type, CHAR(36) can be to store such values.

NEWID()

PATINDEX

patindex.sql

This function is a partial compatibility implementation of MS SQL Server's PATINDEX function. It returns the startposition of the first occurence of a given pattern in a VARCHAR.

PATINDEX(p_pattern IN VARCHAR2(4000), p_expr IN VARCHAR2(4000)) RETURN NUMBER