SQL GETDATE()

The SQL GETDATE() is a SQL Server function which will return current SQL Server system date and time. It is similar to SQL NOW() function in mySQL or SELECT SYSDATE FROM DUAL in Oracle.


Note: In SQL Server, we can also use CURRENT_TIMESTAMP or {fn NOW()} to get the current date time, but the SQL GETDATE() is the most popular.

SQL GETDATE() Syntax

SELECT GETDATE()

SQL GETDATE() Example

Table: Coupons

CouponID CouponName Description ExpireDate
1 Val20 $20 Value coupon August 25, 2011
2 Val60 $60 Value coupon March 10, 2011
3 Off05 5% off July 31, 2011
4 Off15 15% off June 15, 2011

We want to select all the coupons that are not expired:

SELECT CouponID, CouponName
FROM Coupons
WHERE ExpireDate > GETDATE()

Suppose that the SQL Server’s current system date is July 25, 2011, the result will look like:

CouponID CouponName
1 Val20
3 Off05

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>