Re: Timestamp conversion

["Art Tostaine, Jr." <atostaine@xxxxxxxxx>]

Thank you. This worked for me:

exec Sql set :outTmStp = Timestamp_Format(:inTmStp,
                     'MM/DD/YY HH24:MI');

On Tue, Aug 9, 2022 at 10:40 AM Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:

> With SQL:
> Timestamp_Format('8/3/22 10:02', 'MM/DD/YY HH24:MI'))
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
> Modernization – Education – Consulting on IBM i
>
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
> „Train people well enough so they can leave, treat them well enough so they
> don't want to.“ (Richard Branson)
>
>
> -----Original Message-----
> From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Art
> Tostaine, Jr.
> Sent: Dienstag, 9. August 2022 16:10
> To: RPG programming on the IBM i (AS/400 and iSeries)
> <rpg400-l@xxxxxxxxxxxxxxxxxx>
> Subject: Timestamp conversion
>
> I'm receiving a timestamp in a CSV (generated in Excel) that looks like
> this:
>
> 8/3/22 10:02
>
> Is there a way to automatically move it to a timestamp field or do I need
> extract the date and time separately, etc?
>
> Thanks
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list To post a
> message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
> change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link:
> https://amazon.midrange.com
>
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com