OK

but i need to search between dates

like this i can not !!!

SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)  

 , DATEADD(mm,DATEDIFF(mm,-1,GETDATE()),0)

i need to search from

first day of the month

 the-1

 and  between

last

28 OR...

 i think i found

the first day of the month

select DATEADD(m,DATEDIFF(m,0,GETDATE()),0)

the last dat of the month

SELECT DateAdd(day,-1,DateAdd(month,DateDiff(month,0,getdate())+1,0))

i am confused !!!

i dont Know what to do i tray all advise from all the wonderful group of people here but i am steel have the same problem !!

this...

no i try it

-----

DECLARE @a DATETIME, @b-2 DATETIME

SELECT @a = GETDATE()-2, @b-2 = GETDATE()-1

SELECT *

  FROM dbo.MAINB

 WHERE tarih >= CAST(SUBSTRING(CAST(@a AS...

can you fix this for me

---------

DECLARE @StartTime datetime, @EndTime datetime ,@Today  smalldatetime,@Today2  smalldatetime

SET @Today = GETDATE()-2

SET @Today2 = GETDATE()-1

set  @StartTime =@Today+' '+'16:00'

set  @EndTime =@Today2+' '+' 20:00'

SELECT     *

FROM         dbo.MAINB

WHERE...

ok

how to use always the the Date Today like this =(Getdate() +'20:00:00')

-------

SELECT ... FROM ... WHERE startDate >= (Getdate() +'16:00:00') AND endDate <=(Getdate() +'20:00:00')

THNKS

ok my problems

1. i must to search in TOW DATE FIELD

Field one =DateStart

Field Tow=DateEnd

2. how can i use in date format this -'01/11/2005 20:00:00'

thnks

OK what you say is that i cannot use VIEW

only a PROCEDURE ????

Thanks

But i have problem

thet i must use the date of TODAY ONLY !

LIKE THIS

tarih = [  GETDATE()      + ' 16:00:00'   ]

and

tarihB =[  GETDATE()-1     + ' 20:00:00'   ]

Thanks

But i have problem

thet i must use the date of TODAY ONLY !

LIKE THIS

tarih = [  GETDATE()      + ' 16:00:00'   ]

and

tarihB =[  GETDATE()-1     + ' 20:00:00'   ]

ok i wont to search like this

SELECT     TOP 100 PERCENT *

FROM         dbo.MAINB

WHERE    (tarih '01/11/2005 16:00:00') BETWEEN (tarihB  '01/11/2005 20:00:00')

AND (meosar LIKE '1')

the start day is =tarih

the end date is =...

i wont to search between tow dates  Fields !!

the date is

Getdate()-1  16:00  and  Getdate() 16:00

but between tow date fields

start date =datea

end date =dateb

1 datea = Getdate()-1  16:00

2 dateb = Getdate()   ...

can you help me i dont  understand what to do ??

and do you have idea how  to improve it

because i have problem with it !!

thnks

tarih = data Type datetime

length = 8 

tarihb = data Type datetime

length = 8 

thnks

and if i am The ADMINISTRATOR ???