SELECT * FROM ACTLOG WHERE MSGNO IN (406,4952,4954,4958,4960,4957,
4970,4959,4961,4965,4963,4966,4967,4968,4969,4964, 4976, 4981) and
start_time>current_timestamp - 24 hours


On 24 June 2014 19:39, Lepre, James <james.lepre AT solixinc DOT com> wrote:

> Hello Everyone -
>
> I am attempting miserably I might add to write a select statement that
> will produce a bunch of message found in the actlog.  The problem I am
> having is grabbing the data from the last 24 hours..  I will schedule this
> to produce an email each day.. Any thoughts on how to construct this
>
> Thank you
>
> SELECT * FROM ACTLOG WHERE (MSGNO IN
> (406,4952,4954,4958,4960,4957,4970,4959,4961,4965,4963,4966,4967,4968,4969,4964,
> 4976, 4981)) and start_time>=current_timestamp - 24 hours
>
> James Lepre
>
>
>
>
>
> ---------------------------------------------------------------
> Confidentiality Notice: The information in this e-mail and any attachments
> thereto is intended for the named recipient(s) only.  This e-mail,
> including any attachments, may contain information that is privileged and
> confidential  and subject to legal restrictions and penalties regarding its
> unauthorized disclosure or other use.  If you are not the intended
> recipient, you are hereby notified that any disclosure, copying,
> distribution, or the taking of any action or inaction in reliance on the
> contents of this e-mail and any of its attachments is STRICTLY PROHIBITED.
>  If you have received this e-mail in error, please immediately notify the
> sender via return e-mail; delete this e-mail and all attachments from your
> e-mail  system and your computer system and network; and destroy any paper
> copies you may have in your possession. Thank you for your cooperation.
>