An IT Solution

Date Functions Function - Date addition Oracle - (use +) SQL Server - DATEADD My Sql - Need To Update Function - Date subtraction Oracle - (use -) SQL Server - DATEDIFF My Sql - Need To Update Function - Last day of month Oracle - LAST_DAY SQL Server - N/A My Sql - Need To Update Function -Time zone conversion Oracle - NEW_TIME SQL Server - N/A My Sql - Need To Update Function -First weekday after date Oracle - NEXT_DAY SQL Server - N/A My Sql - Need To Update Function -Convert date to string Oracle -TO_CHAR SQL Server - DATENAME My Sql - Need To Update Function -Convert date to number Oracle -TO_NUMBER(TO_CHAR()) ...

String Functions Function - Convert character to ASCII Oracle - ASCII SQL Server - ASCII My Sql - ASCII Function -String concatenate Oracle - CONCAT SQL Server - (expression + expression) My Sql - CONCAT Function -Convert ASCII to character Oracle - CHR SQL Server - CHAR My Sql - CONCAT Function -Return starting point of character in character string (from left) Oracle - INSTR SQL Server - CHARINDEX My Sql - INSTR Function -Convert characters to lowercase Oracle - LOWER SQL Server - LOWER My Sql - LOWER Function -Convert characters to uppercase Oracle - UPPER SQL Server - UPPER My Sql - UPPER Function -Pad left side of character string Oracle - LPAD SQL Server - N/A My Sql - LPAD Function -Remove leading blank spaces Oracle - LTRIM SQL Server - LTRIM My Sql - LTRIM Function -Remove trailing bl...