Answers for "get date day sql"

SQL
-1

get day in sql

SELECT DATEPART(m, GETDATE()) as theMonth  -- returns 11
SELECT DATEPART(d, GETDATE()) as theDay   -- returns 20
SELECT DATEPART(yy, GETDATE()) as theYear   -- returns 2013
Posted by: Guest on September-04-2020
0

how to get date in sql

SELECT CURRENT_DATE from dual;
Posted by: Guest on January-28-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language