

Specialist II
2016-07-08
08:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to get year in sql
Hi,
Like in Qlik with year(Today()) we get output as 2016
In Sql to get Current Year what would be the syntax?
721 Views
2 Replies


Partner - Champion
2016-07-08
08:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For SQL Server use year(getdate())


Specialist II
2016-07-08
09:01 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Getting below error.. pls suggest
648 Views
