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...
DB2 Timestamp Conversion
2 posts
• Page 1 of 1
DB2 Timestamp Conversion
by chris_hird on Tue Feb 23, 2010 1:40 am
Shield Advanced Solutions Ltd
Home of JobQGenie and the Receiver Apply Program
http://www.shield.on.ca/Blog
Home of JobQGenie and the Receiver Apply Program
http://www.shield.on.ca/Blog
- chris_hird
- Posts: 168
- Joined: Fri Apr 10, 2009 12:41 am
- Location: Toronto
Re: DB2 Timestamp Conversion
by scottgcampbell on Tue Feb 23, 2010 4:06 am
I haven't used timestamps but could it be a CCSID problem?
Similar to this?
http://forums.zend.com/viewtopic.php?f=64&t=2470&p=9076&hilit=ccsid#p9076
Scott
Similar to this?
http://forums.zend.com/viewtopic.php?f=64&t=2470&p=9076&hilit=ccsid#p9076
Scott
- scottgcampbell
- Posts: 88
- Joined: Wed Apr 22, 2009 2:29 pm
- Location: Edmonton, AB, Canada
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest