Hi,
Can anyone help how to aggregated the time in datastage,like in my input the time is 09:35:52.I want to rounded this time as 10:00:00.If it is 09:25:23 i need to be rounded as 09:00:00.
Thanks&Regards.
aggregated the timestamp
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Your input is hh:mm:ss. Just check if your Input.time[4,2] >= 30 Then increment hh part and make mm and ss as zeros. Be careful about the hh threshold on am or pm and put conditions to take care of that.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>