check the date format, it should be MM/DD/YYYY On Thu, Jul 29, 2010 at 6:13 PM, Jeena Ajiesh <[email protected]> wrote:
> *Thanks for the reply.* > *I tried this option, but still no result. > * > On Thu, Jul 29, 2010 at 2:57 PM, Jamie Fraser <[email protected]>wrote: > >> DECLARE @TargetDate datetime >> SET @TargetDate = '7/29/2010 9:15:00' >> >> SELECT >> Message >> FROM >> MyTable >> WHERE >> FromDate <= @TargetDate >> AND >> ToDate >= @TargetDate >> >> On Wed, Jul 28, 2010 at 9:32 AM, Jeena Ajiesh <[email protected]> wrote: >> > Dear friends, >> > >> > im stucked in a problem. >> > in database im having fromdate,todate, message and id >> > fromdate & todate contains dates with time. >> > >> > Eg in DB:Fromdate >> > Todate Message Id >> > 7/25/2010 10:00:00 AM 8/1/2010 12:00:00 PM >> > Test abc >> > 7/25/2010 9:00:00 PM 8/1/2010 10:00:00 PM >> > Hello abc >> > >> > Im passing a date 7/29/2010 9:15:00 PM.So i need to get the message from >> > table as 'Hello' >> > >> > i tried a query SELECT MESSAGE FROM TABLENAME WHERE '7/29/2010 9:15:00 >> PM >> > BETWEEN FROMDATE AND TODATE >> > Can u please help in giving a correct query to retrieve the correct >> message >> > in DB based on the datetime passing. >> > >> > >> > *************** >> > Thanks & Regards, >> > Jeena Ajiesh >> > >> > >> > > > > -- > **************** > **Thanks & Regards, > Jeena Ajiesh > Email: [email protected] > [email protected]* > >
