Select dateofPurchase from purchase_tbl where dateofPurchase
Between convert(datetime,convert(nvarchar,datepart(year,GetDate()))+'-1-1') and GetDate()
Tag: Between, Between two dates, Current Year, First Day, Last Day, Sql server
Between convert(datetime,convert(nvarchar,datepart(year,GetDate()))+'-1-1') and GetDate()
Tag: Between, Between two dates, Current Year, First Day, Last Day, Sql server
No comments:
Post a Comment