Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 DB2 Date to SQL Date

Author  Topic 

Starting Member

27 Posts

Posted - 2014-11-19 : 03:46:44
In the DB2 database, the date is stored as a packed decimal P 9.0, I need to convert it to the date format to reconcile the field.

DB2 Database date: 7 digits eg 1080401

Could anyone help me with the conversion.

Many Thanks

Most Valuable Yak

15732 Posts

Posted - 2014-11-19 : 07:08:03
Please do not cross post:
Go to Top of Page

- Advertisement -