Differences

This shows you the differences between two versions of the page.

sql-server-to-mariadb [December 19, 2017 11:00 pm]
sqlines
sql-server-to-mariadb [December 19, 2017 11:05 pm] (current)
sqlines
Line 42: Line 42:
Datetime data types: Datetime data types:
-| | **SQL Server** || **MariaDB** |||| +| | **SQL Server** || **MariaDB** || 
-| 1 | DATE | Date (year, month and day) | DATE |||| +| 1 | DATE | Date (year, month and day) | DATE || 
-| 2 | DATETIME | Date and time with fraction (milliseconds) | DATETIME(3) |||| +| 2 | DATETIME | Date and time with fraction (milliseconds) | DATETIME(3) || 
-| 3 | DATETIME2(//p//) | Date and time with fraction, 0 <= //p// <= 7 | DATETIME(//p//) |||+| 3 | DATETIME2(//p//) | Date and time with fraction, 0 <= //p// <= 7 | DATETIME(//p//) | //p// <= 6  {{:exclamation.png|}}
-| 4 | DATETIMEOFFSET(//p//) | Date and time with fraction and time zone {{:exclamation.png|}}, 0 <= //p// <= 7 | DATETIME(//p//) |||+| 4 | DATETIMEOFFSET(//p//) | Date and time with fraction and time zone {{:exclamation.png|}}, 0 <= //p// <= 7 | DATETIME(//p//) | //p// <= 6  {{:exclamation.png|}}
-| 5 | SMALLDATETIME | Datetime (year, month, day, hour, minutes and 00 seconds {{:exclamation.png|}}) | DATETIME |||| +| 5 | SMALLDATETIME | Datetime (year, month, day, hour, minutes and 00 seconds {{:exclamation.png|}}) | DATETIME || 
-| 6 | TIME(//p//) | Time (Hour, minute, second and fraction), 0 <= //p// <= 7 | TIME(//p//) ||||+| 6 | TIME(//p//) | Time (Hour, minute, second and fraction), 0 <= //p// <= 7 | TIME(//p//) | //p// <= 6  {{:exclamation.png|}} |
===== Built-in SQL Functions ===== ===== Built-in SQL Functions =====