Hi,
I have a table 'X' with a field called 'B'
I need to pass next day date to the field 'B'
I have to do this in the Transformer what function I can use for this.
Is there any help on this
Thanks.
Date
Moderators: chulett, rschirm, roy
Try this:
Code: Select all
DateFromJulianDay((JulianDayFromDate(CurrentDate())+1))
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The Transformer stage itself can not pass the date to the the table; it can calculate the date as swades indicates. But to pass it to the table you will need the appropriate database stage type. You will also need that the data type of column B is compatible with Date.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.