Answers for "sql where year"

print year of a date sql

SELECT EXTRACT(YEAR FROM CURRENT_DATE)

Posted by: Guest on November-22-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 "sql where year"