SQL Server/T-SQL Tutorial/Date Functions/GETDATE

CONVERT(varchar,GETDATE(),113) "dd Mmm yyyy hh:mm:ss:mmm"

3> select CONVERT(varchar,GETDATE(),113) "dd Mmm yyyy hh:mm:ss:mmm"
4> GO
dd Mmm yyyy hh:mm:ss:mmm
------------------------------
17 Aug 2008 13:13:00:710
(1 rows affected)
1>

GETDATE function returns the current system date and time of the server.

4>
5> SELECT GETDATE()
6> GO
-----------------------
2008-08-11 21:34:41.793
(1 rows affected)
1>

select CONVERT(varchar,GETDATE(),108) "hh:mm:ss"

3> select CONVERT(varchar,GETDATE(),108) "hh:mm:ss"
4> GO
hh:mm:ss
------------------------------
13:13:00
(1 rows affected)

select CONVERT(varchar,GETDATE(),114) "hh:mm:ss:mmm"

4> select CONVERT(varchar,GETDATE(),114) "hh:mm:ss:mmm"
5> GO
hh:mm:ss:mmm
------------------------------
13:13:00:570
(1 rows affected)

Select GETDATE()

4> Select GETDATE()
5> GO
-----------------------
2008-08-12 20:24:17.060
(1 rows affected)

SELECT GETDATE() + 14

4> SELECT GETDATE() + 14
5> GO
-----------------------
2008-08-31 13:20:40.710
(1 rows affected)
1>

Use GetDate() function in where clause

2>
3> CREATE TABLE Orders (
4>      OrderID int NOT NULL ,
5>      CustomerID nchar (5) NULL ,
6>      EmployeeID int NULL ,
7>      OrderDate datetime NULL ,
8>      RequiredDate datetime NULL ,
9>      ShippedDate datetime NULL ,
10>     ShipVia int NULL ,
11>     Freight money NULL DEFAULT (0),
12>     ShipName nvarchar (40) NULL ,
13>     ShipAddress nvarchar (60) NULL ,
14>     ShipCity nvarchar (15) NULL ,
15>     ShipRegion nvarchar (15) NULL ,
16>     ShipPostalCode nvarchar (10) NULL ,
17>     ShipCountry nvarchar (15) NULL)
18>
19> GO
1>
2>
3>    SELECT * FROM Orders WHERE OrderDate = GETDATE()
4> GO
OrderID     CustomerID EmployeeID  OrderDate               RequiredDate            ShippedDate             ShipVia     Freight               ShipName                                 ShipAddress
                                           ShipCity        ShipRegion      ShipPostalCode ShipCountry
----------- ---------- ----------- ----------------------- ----------------------- ----------------------- ----------- --------------------- ---------------------------------------- ------------------
------------------------------------------ --------------- --------------- -------------- ---------------
(0 rows affected)
1>
2> drop table Orders;
3> GO
1>