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
>
>
