Re: query regarding system time

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 10 Sep 2005 12:52:14 +0200
Message-ID: <dfudeg$q1v$2@news2.zwoll1.ov.home.nl>

June Moore wrote:
> Hi,
> Is there any way I can check if the system time is between a certain
> range (e.g. 3 - 9 pm)?
> e.g. select * from <table> where systime >= "15:00" and systime <=
> "21:00";
>
> thanks..
> JM
>

Yes.
Using sysdate, actually.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Sat Sep 10 2005 - 05:52:14 CDT

This message: [ Message body ]
Next message: Frank van Bortel: "Re: takveen SPAM"
Previous message: Frank van Bortel: "Re: using bind variables makes the optimizer choose a bad plan"
In reply to: June Moore: "query regarding system time"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US