MySQL IF() Function Datetime Example

MySQL IF() Function Datetime Example

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

   SELECT now(), now()-1, now()+10, now()-10, IF(now() > now()-1, now()+10, now()-10) AS Results;
   --
   SELECT now(), now()-1, now()+10, now()-10, IF(now() < now()-1, now()+10, now()-10) AS Results;
   --
   SELECT now(), now()-1, now()+10, now()-10, IF(now() != now()-1, now()+10, now()-10) AS Results;
   --
   SELECT now(), now()+10, now()-10, IF(NULL, now()+10, now()-10) AS Results;

   -- MySQL IF() Function Compares Three Expressions
   --
   -- if    [Expression1/Value1] evaluates to true, returns [Expression2/Value2]
   -- else  [Expression3/Value3]

      -- is comment in MySQL
      -- in fact it is comment in MSSQL and Oracle as well
   

MySQL IF() Function Datetime Example - Result in MySQL Query Editor

 

Related Tutorial Examples

  1. MySQL IF() Function Boolean Value Example
  2. MySQL IF() Nested Function Example
  3. MySQL IF() Function NULL Value Example
  4. MySQL IF() Function String Value Example
  5. MySQL IF() Function Number Value Example
  6. MySQL IFNULL() Function NULL Value Example
  7. MSSQL PRINT Like Function in MySQL Example
  8. How to Find MySQL Stored Procedure or Function Information
  9. Describe Table Structure using SQL Command MySQL Example
  10. SELECT specific columns using SQL Command MySQL Example

No comments:

Post a Comment

leave your comments here..