Answers for "get actual year as number sql server"

get current month last date in sql server

SELECT EOMONTH('2019-02-15') end_of_month_feb2019;

Posted by: Guest on August-19-2020

current year sql

-- Oracle
SELECT extract(YEAR FROM sysdate) FROM dual;			// number
SELECT to_char(sysdate, 'YYYY') FROM dual;				// varchar

Posted by: Guest on May-04-2021

Code answers related to "get actual year as number sql server"