Sai Reddy

Sai Reddy

  • NA
  • 214
  • 31.6k

SQL PUZZLE WITH Date Function

May 31 2018 2:27 AM
Hi,
 
I found the following query some where in the google .
 
SELECT YEAR(35000/20) AS YEAR_VALUE----> Output = 1904
 
As you can see that 35000/20 is not a valid date value. The matter of the fact 35000/20 is results in value 1750.

Answers (3)