hi,
I have to bring the latest date from a table which has tis column.I used the aggeragator groping on dummy and pulled the maximum value, now the valuse by default is in double, but i need to palce it in the datetime feild ib the target table. I am using 8.1, there is no direct decimal to date conversion function, sow can i convert fron double to date format?
Getting Maximum Date using Aggregator, double to date how?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The only real question is, is the Preserve Type property available in version 8.1?
If not, convert all your timestamps to seconds from an arbitrary zero point, aggregate them, and convert them back.
If not, convert all your timestamps to seconds from an arbitrary zero point, aggregate them, and convert them back.
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.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI