Re: How to get a date field and hivals for the time portion intoa timestamp

hi Andy,

Andy Hautamaki wrote:

I have a timestamp field that I want to have updated with a date field and
hivals for the time portion of the timestamp.

Both your data structure example, and Adam's example fail to set the
microseconds portion of the timestamp. They set the hour, minutes, and
seconds to their highest value, but leave the microseconds set to zero.

IMHO, that's misleading. But if that's really what you want, here's a
way that seems more intuitive to me (very similar to Adam's)

D maxtime s T inz(*HIVAL)

MyTimestampField = myDateField + maxtime;

However, if it were me, I'd want to set the microseconds as well. To do
that, I'd do something like this:

D maxtime c '235959999999'

MyTimestampField = %timestamp( %char(myDateField:*iso0)
+ maxtime
: *ISO0 );

Good luck
--
This is the RPG programming on the AS400 / 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.