Tuesday, December 29, 2009

SQL Function Reference:Oracle vs.SQL Server vs. My SQL Part- III

1 comment
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())
SQL Server - TO_NUMBER(TO_CHAR())
My Sql - Need To Update

Function -Convert string to date
Oracle -TO_NUMBER(TO_CHAR())
SQL Server - CAST
My Sql - Need To Update

Function -Get current date and time
Oracle -SYSDATE
SQL Server - GETDATE()
My Sql - Now()

1 comments:

RING said...

愛情不是慈善事業,不能隨便施捨。.........................