Xavier
|
Posted: 06/07/2002, 1:25 AM |
|
Hello,
I have a table where some "help requests" are stored with their insertion
time.
I'd like to select some of them on a time base, I mean I'd like to choose
for instance those between a date and another. How can I do it? Which kind
of field should I use?
Thanks,
Xavier
|
|
|
Alexey Alexapolsky
|
Posted: 06/12/2002, 2:39 AM |
|
This depends on your database type.
Usually you use BETWEEN datefield1 AND datefield2 in WHERE clause,
you can also use <> and <= >= operators.
--
Alex
CodeCharge Developer
"Xavier" <nobody@nowhere.invalid> wrote in message
news:adpql9$kp9$1@news.codecharge.com...
> Hello,
> I have a table where some "help requests" are stored with their insertion
> time.
> I'd like to select some of them on a time base, I mean I'd like to choose
> for instance those between a date and another. How can I do it? Which kind
> of field should I use?
>
> Thanks,
> Xavier
>
>
|
|
|
|