Hi friends,
I want to add "5months and two weeks" in a date column(Timestamp).
What is the function i need to use. Can anybody help me on this.
Thanks.
Adding a month in a Date column
Moderators: chulett, rschirm, roy
Adding a month in a Date column
Gopinath
Hi,chulett wrote:Search for DaysFromDateSince. And then decide what "5 months and 2 weeks" means - 154 days? And is it a date or a timestamp? ...
It's a Timestamp field. Will it work for Timestamp also. Let me try this option and also pls let me know if any other method is there for
Timestamp.
Thanks.
Gopinath
Hi,chulett wrote:Search for DaysFromDateSince. And then decide what "5 months and 2 weeks" means - 154 days? And is it a date or a timestamp? ...
It's a Timestamp field. Will it work for Timestamp also. Let me try this option and also pls let me know if any other method is there for
Timestamp.
Thanks.
Gopinath
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You need to add five months then add two days, perhaps in two stage variables in the Transformer stage. This requirement can not be done as a single generic function because month lengths are unequal. Is there anything special about "five months and two days" (just curious) or is this a specific example of a more general problem to solve?
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: