Hi,
Having a problem I am sure I have seen before, but going over my past projects, I have not found the solution I used before.
I am updating from AS400 to the same AS400 with a hash file staging point after a transformer.
The objective is to put today's date in the target field (Decimal 15,6) in the format YYYYMMDD.
However, for todays date, I would expect for example 20080415.000000...and I SEE 20080415 in my staging point file. However, in AS400, we are getting 4258146.000000
I seem to recall this was something about needing to convert the data format before loading to character or something like that...but I cannot find an example of what I did before.
Any ideas?
Thanks
Wade
AS400 & Date format YYYYMMDD
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 40
- Joined: Thu Mar 30, 2006 6:30 am
- Location: Near Geneva, Switzerland
- Contact:
AS400 & Date format YYYYMMDD
Wade Walker
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: