Re: Set TimeStamp To Beginning of day

[Michael Ryan <michaelrtr@xxxxxxxxx>]

How about just looking at the date portion, and order it by Modify_Time?


On Thu, Apr 24, 2014 at 1:00 PM, (WalzCraft) Jerry Forss <
JForss@xxxxxxxxxxxxx> wrote:

> Hi All,
>
> The user enters the date they want to select like 20140424.
> The items I am selecting from are PDF's on the IFS.
>
> I want to use the WHERE to select on the Modify_Time selecting on the
> timestamp of the day the user entered.
>
> What I need is a timestamp set to the start of the day 2014.04.24 00.00.00
> and another 2014.04.24 24.00.00 for the end of the day.
>
> How do I set those timestamp variables like that?  Drawing a blank.
>
> Exec SQL  Declare C1 Cursor For
>              Select FileName, Size, Type, Create_Time,
>                  Access_Time, Modify_Time, Change_Time
>              From Table(IFSDir(:Path)) as T
>              Where Modify_Time >= StartStamp And Modify_Time <= EndStamp
>
> Thanks!!
>
>
> Subject to Change Notice:
>
> WalzCraft reserves the right to improve designs, and to change
> specifications without notice.
>
> Confidentiality Notice:
>
> This message and any attachments may contain confidential and privileged
> information that is protected by law. The information contained herein is
> transmitted for the sole use of the intended recipient(s) and should "only"
> pertain to "WalzCraft" company matters. If you are not the intended
> recipient or designated agent of the recipient of such information, you are
> hereby notified that any use, dissemination, copying or retention of this
> email or the information contained herein is strictly prohibited and may
> subject you to penalties under federal and/or state law. If you received
> this email in error, please notify the sender immediately and permanently
> delete this email. Thank You;
>
> WalzCraft PO Box 1748 La Crosse, WI. 54602-1748
>
> www.walzcraft.com<http://www.walzcraft.com/> Phone... 800-237-1326
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.