DB2 Timestamp Conversion

General discussion on Zend Core for IBM System i
Post Reply
Posts: 171
Joined: Fri Apr 10, 2009 12:41 am
Location: Toronto

DB2 Timestamp Conversion

Post by chris_hird » Tue Feb 23, 2010 1:40 am

Does anyone know how to convert a timestamp from a DB2 file? I have tried every date function possible and non of them actually return a formatted date?

When simply output the returned row content I get values such as k“Ši”©€ so it even look like its not converting from the original hex value?

Shield Advanced Solutions Ltd
Home of JobQGenie and the Receiver Apply Program

Posts: 187
Joined: Wed Apr 22, 2009 2:29 pm
Location: Edmonton, AB, Canada

Re: DB2 Timestamp Conversion

Post by scottgcampbell » Tue Feb 23, 2010 4:06 am

I haven't used timestamps but could it be a CCSID problem?

Similar to this?


Post Reply