How to display records from todays date and specifiec time of the day

[MeTin]

Hi all


any idea how to display specific record on current date and time of the day
...
i did managed to display it for the date and drop it on specific date but
couldn manage it to dispay on speci,fic time of the date (for example 6
o'clock in the evening drop from the list)
i work with ASP and access 2000 and i have done it like

SELECT *
FROM students_table
WHERE students_pass_exam <=now
ORDER BY students_pass_exam ASC

So can u pls help me out how to do it to dissapear at the current time of
the last day instead of after midnight of the last date ...


Pls gimme some tips ..


Rgrds MeTin

[Manuel Socarras]

try the Hour function


MeTin wrote:

> Hi all
>
>
> any idea how to display specific record on current date and time of the day
> ..
> i did managed to display it for the date and drop it on specific date but
> couldn manage it to dispay on speci,fic time of the date (for example 6
> o'clock in the evening drop from the list)
> i work with ASP and access 2000 and i have done it like
>
> SELECT *
> FROM students_table
> WHERE students_pass_exam <=now
> ORDER BY students_pass_exam ASC
>
> So can u pls help me out how to do it to dissapear at the current time of
> the last day instead of after midnight of the last date ...
>
>
> Pls gimme some tips ..
>
>
> Rgrds MeTin
>
>

[MeTin]

Hi Manuel

But this didnt help out ..can u recommend me any another way for this ...



Rgds MeTin


"Manuel Socarras" <msoc**no-spam**@airtel.net> wrote in message
news:cvpkbs$jqp$1@forums.macromedia.com...

> try the Hour function
>
>
> MeTin wrote:

>> Hi all
>>
>>
>> any idea how to display specific record on current date and time of the
>> day ..
>> i did managed to display it for the date and drop it on specific date but
>> couldn manage it to dispay on speci,fic time of the date (for example 6
>> o'clock in the evening drop from the list)
>> i work with ASP and access 2000 and i have done it like
>>
>> SELECT *
>> FROM students_table
>> WHERE students_pass_exam <=now
>> ORDER BY students_pass_exam ASC
>>
>> So can u pls help me out how to do it to dissapear at the current time of
>> the last day instead of after midnight of the last date ...
>>
>>
>> Pls gimme some tips ..
>>
>>
>> Rgrds MeTin