Re: date from DB2 window to DB2 Ibm I

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

+1 - timestamp_format is a life saver, IMO!

On 7/14/2017 12:26 AM, Birgitta Hauser wrote:
> The easiest way is to pass a character representation of a timestamp.
> Character timestamps in either the ISO Format ('YYYY-MM-DD-HH.MI.SS.MSMSMS')
> or ANSI-Format ('YYYY-MM-DD HH:MI:SS.MSMSMS') or in the following format
> 'YYYYMMDDHHMISS') can be converted directly into a timestamp.
> No need for using an additional scalar function.
> A (character) timestamp representation in almost any other format can be
> converted with the TIMESTAMP_FORMAT Function into a real timestamp.
>
> Example: Values(Timestamp_Format('14.07.17 07:23': 'DD.MM.YY HH24:MI')
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "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 [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of gio.cot
> Sent: Donnerstag, 13. Juli 2017 19:36
> To: rpg400-l@xxxxxxxxxxxx
> Subject: date from DB2 window to DB2 Ibm I
>
> I all
>
> I'm reading a DB2 table in a windows server (via JDCBR4) ; in this table
> there a timestamp column with value like this "2017-02-16 14:15:55.321", in
> my Ibm I table I have a column type "Z" .. how can I to convert the value
> from DB2 windows to DB2 Ibm I
>
> Thanks
>
> --
> 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link:
> http://amzn.to/2dEadiD