Date to Integer Conversion in Db2 query

Suman · Post by **Suman** » Sat Jun 17, 2006 7:01 am

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

chulett · Post by **chulett** » Sat Jun 17, 2006 8:18 am

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.

DSguru2B · Post by **DSguru2B** » Sat Jun 17, 2006 10:14 am

There are a few date/timestamp manipulation function in UDB. Your best bet would be google.
Check this site out for a start. Also the IBM's public library.

ray.wurlod · Post by **ray.wurlod** » Sat Jun 17, 2006 3:28 pm

Try the DaysSinceFromDate() function.