"Where" Clause in SQL

Which syntax we can use to find particular year like "80" in a data which has date format "1980/12/01"?

  Rupesh Kumar

You can use below mentioned syntax to get the required information:

select * from table_name

where right(year(date_Column),2) = '80' 

  Devbrat Tripathi       29 Jun 2016       0       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any