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.
搜索
论坛
Home
回顶部
1. ODBC and timestamps
g.yi.org Hits:0
