Answers for "get year sql"

SQL
0

get current year sql

select year(getdate())
Posted by: Guest on June-14-2020
1

print year of a date sql

SELECT EXTRACT(YEAR FROM CURRENT_DATE)
Posted by: Guest on November-22-2020
-1

sql year

select 
  to_char(a.create_date,'yyyy') as date_year,
  count(*) as num
from sys_bug a
left join sys_user u on u.id = a.create_by 
left join sys_office o on o.id = u.office_id
group by to_char(a.create_date,'yyyy')
1234567
Posted by: Guest on August-25-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language