select * from ShopOrder where datediff(week,ordTime,getdate()-1)=0 //
select * from ShopOrder where datediff(day,ordTime,getdate()-1)=0 //
SELECT * FROM A where datediff(d,datetime,getdate()) <=30 // 30
SELECT * FROM A WHERE DATEDIFF(m, shijian, GETDATE()) <=1 //
-- :
select * from info where DateDiff(dd,datetime,getdate())=0
-- 24 :
select * from info where DateDiff(hh,datetime,getDate())<=24
--info ,datetime
-- :
select * from info where DateDiff(dd,datetime,getdate())=0
-- 24 :
select * from info where DateDiff(hh,datetime,getDate())<=24
--info ,datetime
Sql
--
SELECT *
FROM j_GradeShop
WHERE (GAddTime BETWEEN CONVERT(datetime, LEFT(GETDATE(), 10) + ' 00:00:00.000')
AND CONVERT(datetime, LEFT(GETDATE(), 10) + ' 00:00:00.000') + 1)
ORDER BY GAddTime DESC
--
SELECT *
FROM j_GradeShop
WHERE (GAddTime BETWEEN CONVERT(datetime, LEFT(GETDATE(), 10) + ' 00:00:00.000')
AND CONVERT(datetime, LEFT(GETDATE(), 10) + ' 00:00:00.000') + 1)
ORDER BY GAddTime DESC
DATEDIFF :
:
DATEDIFF ( datepart , startdate , enddate )
:enddate startdate。 startdate enddate, 。
, DATEDIFF 。 , 24 20 31 23.647 。 , 68 。
、 DATEDIFF 。 , datepart 。 , 1 4 ( ) 1 11 ( ) 1。
MSSQL :
Sql
-- 24
--
print dateDiff(hh,'2009-1-1 0:0:0','2009-1-2 0:0:0')
--
print dateDiff(hh,'2009-1-1 0:0:0','2009-1-2 0:0:0')
-- 24
--
print dateDiff(hh,'2009-1-1 0:0:0','2009-1-2 0:0:0')
--
print dateDiff(hh,'2009-1-1 0:0:0','2009-1-2 0:0:0')
Sql
--
SELECT * FROM WHERE datediff(month,[dateadd],getdate())=0
--
SELECT * FROM WHERE datediff(week,[dateadd],getdate())=0
--
--
SELECT * FROM WHERE datediff(month,[dateadd],getdate())=0
--
SELECT * FROM WHERE datediff(week,[dateadd],getdate())=0
--
sql server
1. 、
select getdate()
2. dateadd , datetime
: 2
select dateadd(day,2,'2004-10-15') -- :2004-10-17 00:00:00.000
3. datediff 。
select datediff(day,'2004-09-01','2004-09-18') -- :17
4. datepart 。
SELECT DATEPART(month, '2004-10-15') -- 10
5. datename
SELECT datename(weekday, '2004-10-15') -- :
6. day(), month(),year() -- datepart
select =convert(varchar(10),getdate(),120)
, =convert(varchar(8),getdate(),114)
select datename(dw,'2004-10-15')
select =datename(week,'2004-10-15')
, =datename(weekday,'2004-10-15')
/
GetDate( )
DateDiff (interval,date1,date2) interval , date2 date1 date2-date1
DateAdd (interval,number,date) interval , number
DatePart (interval,date) date ,interval
DateName (interval,date) date ,interval
interval :
(Sql Server) Access ASP
Year Yy yyyy 1753 ~ 9999
Quarter Qq q 1 ~ 4
Month Mm m 1 ~ 12
Day of year Dy y , 1-366
Day Dd d ,1-31
Weekday Dw w , 1-7
Week Wk ww , 0 ~ 51
Hour Hh h 0 ~ 23
Minute Mi n 0 ~ 59
Second Ss s 0 ~ 59
Millisecond Ms - 0 ~ 999
access asp date() now() ; DateDiff,DateAdd,DatePart Access asp ,
:
1.GetDate() sql server :select GetDate()
2.DateDiff('s','2005-07-20','2005-7-25 22:56:32') 514592
DateDiff('d','2005-07-20','2005-7-25 22:56:32') 5
3.DatePart('w','2005-7-25 22:56:32') 2 ( 1, 7)
DatePart('d','2005-7-25 22:56:32') 25 25
DatePart('y','2005-7-25 22:56:32') 206 206
DatePart('yyyy','2005-7-25 22:56:32') 2005 2005