SQL server date functions

To find current date and time : select SYSDATETIME();

To display only date : select convert(date,SYSDATETIME());

To display only time : select convert(time,SYSDATETIME());

Here is the query to display all this above.

select SYSDATETIME() as Timestamp,convert(date,SYSDATETIME()) as Date,CONVERT(time,SYSDATETIME()) as Time;

SQL server date functions

To find current date and time : select SYSDATETIME();

To display only date : select convert(date,SYSDATETIME());

To display only time : select convert(time,SYSDATETIME());

Here is the query to display all this above.

select SYSDATETIME() as Timestamp,convert(date,SYSDATETIME()) as Date,CONVERT(time,SYSDATETIME()) as Time;

SQL Extract Datetime function

EXTRACT extracts and returns the value of a specified datetime field from a datetime or interval value expression.

To extract YEAR from SYSDATE or SYSTIMESTAMP or Date/Timestamp column.

SELECT EXTRACT(YEAR FROM SYSDATE) FROM DUAL;

SELECT EXTRACT(YEAR FROM SYSTIMESTAMP) FROM DUAL;

SELECT EXTRACT(YEAR FROM COLUMN) FROM DUAL;



To extract MONTH from SYSDATE or SYSTIMESTAMP or Date/Timestamp column.

SELECT EXTRACT(MONTH FROM SYSDATE) FROM DUAL;

SELECT EXTRACT(MONTH FROM SYSTIMESTAMP) FROM DUAL;

SELECT EXTRACT(MONTH FROM COLUMN) FROM DUAL;


To extract DAY from SYSDATE or SYSTIMESTAMP or Date/Timestamp column.

SELECT EXTRACT(DAY FROM SYSDATE) FROM DUAL;

SELECT EXTRACT(DAY FROM SYSTIMESTAMP) FROM DUAL;

SELECT EXTRACT(DAY FROM COLUMN) FROM DUAL;

NOTE: Column should be in Date or Timestamp.

SQL Extract Datetime function

EXTRACT extracts and returns the value of a specified datetime field from a datetime or interval value expression.

To extract YEAR from SYSDATE or SYSTIMESTAMP or Date/Timestamp column.

SELECT EXTRACT(YEAR FROM SYSDATE) FROM DUAL;

SELECT EXTRACT(YEAR FROM SYSTIMESTAMP) FROM DUAL;

SELECT EXTRACT(YEAR FROM COLUMN) FROM DUAL;



To extract MONTH from SYSDATE or SYSTIMESTAMP or Date/Timestamp column.

SELECT EXTRACT(MONTH FROM SYSDATE) FROM DUAL;

SELECT EXTRACT(MONTH FROM SYSTIMESTAMP) FROM DUAL;

SELECT EXTRACT(MONTH FROM COLUMN) FROM DUAL;


To extract DAY from SYSDATE or SYSTIMESTAMP or Date/Timestamp column.

SELECT EXTRACT(DAY FROM SYSDATE) FROM DUAL;

SELECT EXTRACT(DAY FROM SYSTIMESTAMP) FROM DUAL;

SELECT EXTRACT(DAY FROM COLUMN) FROM DUAL;

NOTE: Column should be in Date or Timestamp.