Answers for "get year of column sql"

get current year sql

select year(getdate())

Posted by: Guest on June-14-2020

select year(uploadtime) as yy,count(*),sum(filetypeid) from sys_base_fileindex GROUP BY yy
1

Posted by: Guest on August-25-2021

Code answers related to "get year of column sql"