Convert SQL Function from MySQL to SQL Server

The list below illustrates how to convert the most popular MySQL built-in functions into SQL Server equivalents:

• convert CURRENT_TIMESTAMP and now() into getdate()
• replace isnull(expression) by expression is null
• replace all occurrenced of from_unixtime(expression) by DateAdd(ss, expression, '01-01-1970')
• replace CURRENT_DATE and curdate() by CAST(getdate() as date)
• convert CURRENT_TIME and curtime() into CAST(getdate() as time)
• replace timediff($date1, $date2) by CAST($date2 - $date1 AS TIME)
• replace 'conact(expr1, expr2, ..., exprN)' by 'expr1 + expr2 + ... + exprN'
• replace 'SELECT ... LIMIT number_of_rows' by 'SELECT TOP number_of_rows ...'
• replace RAND() by newID()
• replace DAY($date) or DAYOFMONTH($date) by DATENAME(d, $date)
• replace DAYOFYEAR($date) by DATENAME(dy, $date)
• replace DAYNAME($date) by DATENAME(dw, $date)
• replace HOUR($date) by DATENAME(hh, $date)

Have questions? Contact us