Re: Trading timestamps with DB2 LUW

[Jim Franz <franz9000@xxxxxxxxx>]

As further note, the DB2 LUW version (yyyy-mm-ddThh:mm:ss) fits the ISO
8601 standard.
Jim

On Tue, Jan 19, 2016 at 2:42 PM, Jim Franz <franz9000@xxxxxxxxx> wrote:

> (Posting to RPG list due to RPGLE web service program to pass timestamp as
> parm)
> I have a requirement to pass timestamp in a format where I don't see RPGLE
> has an option other than generating a text field.
> This is the sample provided and through SOAPUI it works
> <uws:StartDate>2015-12-08T14:26:46</uws:StartDate>
>
> Every variation I try fails, and I have verified on the target system it
> is a "TIMESTAMP".
> 2015-12-08-14.26.46 fails - (nothing selected)
> 2015-12-08-14.26.46.000 and .000000 both fail
>
> Am I missing some understanding of timestamps between DB2 for i and DB2
> LUW (and this is either Linux or unix running Websphere with DB2 9.7.x)
> or is there some edit possible in a timestamp?
> ILE RPG Reference V7R1 says a Timestamp Data Type is always length of 26
> and format is
> yyyy-mm-dd-hh.mm.ss.mmmmmm
>
> Jim