Guidance
指路人
g.yi.org
Guidance Forums / Reginald Rexx / ODBC and timestamps

Register 
注册
Search 搜索
首页 
Home Home
Software
Upload

  
Forum List • Thread List • Reply • Refresh • New Topic • Search • Previous • Next First 1 Last
Message1. ODBC and timestamps
#8307
Posted by: misi01 2006-06-09 16:39:07
Am running a script that fetches data from the mainframe and will insert it into tables on the PC. What surprised me was the fact that the mainframe timestamp value for a specific row is
2027-12-23-09.31.23.678459
but when it comes into REXX via an ODBC fetch, it contains the following
2027-12-23 09.31.23.678459
(note the blank in the middle).

When googling odbc timestamp and format, I discovered that that's the way it is, so YOU have to insert (if needed) a minus sign in position 11.

Thought I'd append this IN CASE anyone else runs into it.
Michael
Forum List • Thread List • Reply • Refresh • New Topic • Search • Previous • Next First 1 Last
掌柜推荐
 
 
 
 
 
 
 
 
 
 
 
 
© Wed 2024-2-28  Guidance Laboratory Inc.
Email:webmaster1g.yi.org Hits:0