DB2 Timestamp Conversion

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

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?

Chris...
Shield Advanced Solutions Ltd
Home of JobQGenie and the Receiver Apply Program
http://www.shield.on.ca/Blog

scottgcampbell
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?
viewtopic.php?f=64&t=2470&p=9076&hilit=ccsid#p9076

Scott

Post Reply