MySQL NULLIF() Function Datetime Value Example

MySQL NULLIF() Function Datetime Value Example

Open your MySQL Query Editor then copy & paste the below code to get the value of NULLIF() MySQL Function Datetime Value Example:

   SELECT now(),  now()-1,  NULLIF(now(),now()), NULLIF(now(),now()-1), NULLIF(0/0,now()), NULLIF(now()>0,100);

   -- MySQL NULLIF() Function Deals With Two Expressions
   -- IF    [Expression1/Value1] equals to [Expression2/Value2] NULLIF() Function returns NULL
   -- ELSE  NULLIF() Function returns [Expression1/Value1]
      -- is comment in MySQL
      -- in fact it is comment in MSSQL and Oracle as well

MySQL NULLIF() Function Datetime Value Example - Result in MySQL Query Editor


Related Tutorial Examples

  1. MySQL NULLIF() Nested Function Example
  2. MySQL NULLIF() Function String Value Example
  3. MySQL NULLIF() Function Number Value Example
  4. MySQL NULLIF() Function Boolean Value Example
  5. MySQL NULLIF() Function NULL Value Example
  6. MySQL IFNULL() Function Datetime Example
  7. MySQL Stored Procedure: Variable Example
  8. MySQL Stored Procedure: Batch Salary Increment Example
  9. MySQL sample database script: Create Database using SQL Statement Example
  10. MySQL Sub-Query: INSERT INTO SELECT... Example

No comments:

Post a Comment

leave your comments here..