Search results
Definition and Usage. The NULLIF () function returns NULL if two expressions are equal, otherwise it returns the first expression. Syntax. NULLIF (expr1, expr2) Parameter Values. Technical Details. More Examples. Example. Compare two expressions: SELECT NULLIF('Hello', 'Hello'); Try it Yourself » Example. Compare two expressions:
- Try It Yourself
Edit the SQL Statement, and click "Run SQL" to see the...
- The Try-SQLSERVER Editor
Edit the SQL Statement, and click "Run SQL" to see the...
- Try It Yourself
24 paź 2017 · You should cast the expression to date: UPDATE del_data.cncpt_rqst SET prpsd_prodn_dt = nullif(#{cncptDt}, '')::date
This tutorial introduces you to the SQL NULLIF function and shows you how to add the if-else condition to your SQL queries.
You would use the SQL NULLIF function when you want to replace a value with NULL in your query result if it matches a specified condition. NULLIF is particularly useful when you need to handle equality as a distinct case, such as when you want to hide or suppress certain results in your query.
NULLIF is equivalent to a searched CASE expression in which the two expressions are equal and the resulting expression is NULL. We recommend that you not use time-dependent functions, such as RAND(), within a NULLIF function.
MONTH(date) Returns the month for date, in the range 1 to 12 for January to December, or 0 for dates such as '0000-00-00' or '2008-00-00' that have a zero month part. Returns NULL if date is NULL. mysql> SELECT MONTH('2008-02-03'); -> 2; MONTHNAME(date) Returns the full name of the month for date.
8 maj 2022 · SQL NULLIF () Explained. Most major RDBMS s support the NULLIF() operator, which returns NULL if both of its arguments are equivalent. If the arguments not equivalent, NULLIF() returns the first argument. NULLIF() is a SQL-standard feature (it’s included in the ISO/IEC 9075 specification).
