Have a Question?

If you have any question you can ask below or enter what you are looking for!

"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