I have to convert date in db2 table into integer in a query.Is there any function available for this conversion? The date format is mm/dd/yyyy and I want the number of days from a low date 01/01/0001.
Thanks,
Suman
Date to Integer Conversion in Db2 query
Moderators: chulett, rschirm, roy
More of a database than a DataStage question. If I was in your shoes, I'd start by chatting up my DBA. Or posting this question in some kind of a DB2 support forum. And posting here, of course, someone will probably know.
I'm guessing you could also write your own, incorporate it into the job itself.
I'm guessing you could also write your own, incorporate it into the job itself.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: