SQL Server/T-SQL Tutorial/Date Functions/GETDATE
Содержание
- 1 CONVERT(varchar,GETDATE(),113) "dd Mmm yyyy hh:mm:ss:mmm"
- 2 GETDATE function returns the current system date and time of the server.
- 3 select CONVERT(varchar,GETDATE(),108) "hh:mm:ss"
- 4 select CONVERT(varchar,GETDATE(),114) "hh:mm:ss:mmm"
- 5 Select GETDATE()
- 6 SELECT GETDATE() + 14
- 7 Use GetDate() function in where clause
CONVERT(varchar,GETDATE(),113) "dd Mmm yyyy hh:mm:ss:mmm"
<source lang="sql">
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></source>
GETDATE function returns the current system date and time of the server.
<source lang="sql">
4> 5> SELECT GETDATE() 6> GO
2008-08-11 21:34:41.793 (1 rows affected) 1></source>
select CONVERT(varchar,GETDATE(),108) "hh:mm:ss"
<source lang="sql">
3> select CONVERT(varchar,GETDATE(),108) "hh:mm:ss" 4> GO hh:mm:ss
13:13:00 (1 rows affected)</source>
select CONVERT(varchar,GETDATE(),114) "hh:mm:ss:mmm"
<source lang="sql">
4> select CONVERT(varchar,GETDATE(),114) "hh:mm:ss:mmm" 5> GO hh:mm:ss:mmm
13:13:00:570 (1 rows affected)</source>
Select GETDATE()
<source lang="sql">
4> Select GETDATE() 5> GO
2008-08-12 20:24:17.060 (1 rows affected)</source>
SELECT GETDATE() + 14
<source lang="sql">
4> SELECT GETDATE() + 14 5> GO
2008-08-31 13:20:40.710 (1 rows affected) 1></source>
Use GetDate() function in where clause
<source lang="sql">
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></source>