date problem

[baran121]

hi.
i want to do a query about date. there is the code


select * from ab_date_def order by sdate between '2008-01-01'
and '2008-03-30' order by sdate

sdate:
2008-03-03 16:52:00
2008-03-07 15:12:00
2008-03-28 14:14:00
2008-01-25 17:45:00
2008-01-25 17:46:00
2008-03-03 16:52:00

i want to get in where only date not time.
plase help me

 

[bborissov]

select * 
      from ab_date_def
WHERE sdate >= '20080101' and sdate < '20080401'
order by sdate

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[k01]

Hi baran121,

You can get the result with this.

select 
  CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, sdate))))  
from 
  ab_date_def 
where
  sdate between '2008-01-01' and '2008-03-30' 
order by 
  sdate

By the way,
You need to take care the condition too when you use the datetime.

This SQL excludes 2008-03-30 11:00:00 data.


koichi

http://aboutabi.blogspot.com/

 

[baran121]

it works k01.
thank you very much