SELECT
CASE WHEN '04/10/2006' < '07/01/2013' THEN 'TRUE' ELSE 'FALSE'
END
Output: TRUE
SELECT
CASE WHEN '10/31/2006' > '07/01/2012' THEN 'TRUE' ELSE 'FALSE'
END
Output: TRUE
This is so confusing. I executed these two query and I got o/p as true for both the queries. The o/p to 1st query is correct. Shouldn't the output to 2nd query be false.? Can someone help please?