Re: Set TimeStamp To Beginning of day

[Stuart Rowe <rowestu@xxxxxxxxx>]

StartStamp = <inputted date> + t'00.00.00';
EndStamp = <inputted date> + t'24.00.00';

Or like Michael said

where date(Modify_Time) = <inputted date>






On Thu, Apr 24, 2014 at 12:03 PM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:

> 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.
> --
> 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.