IF

Evaluates a condition and returns different results based on whether the condition is true or false. The IF function is a simplified alternative to the CASE expression for handling conditional logic.

Syntax

IF(<condition>, <then>, <else>)

Parameters

Parameter	Description	Supported input types
<condition>	Condition that the function evaluates.	BOOLEAN
<then>	Value returned when <condition> evaluates to true.	Any
<else>	Value returned when <condition> evaluates to false or NULL. Must match the data type of <then>.	Any

Return type

The IF function returns the same data type as the <then> and <else> parameters.

Example

The following example uses the IF function to determine if the current day is a weekend or weekday:

SELECT IF(EXTRACT(DOW FROM CURRENT_DATE()) % 6 = 0, 'Weekend', 'Weekday')

The previous query returns:

• Weekend when the current day is Saturday or Sunday.
• Weekday for any other day.