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.le...@solixinc.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. >
