|
||||||
| C and C++ C and C++ forum for discussing all forms of C except for C#. These languages are powerful low level languages used for creating Operating Systems, Device Drivers, compilers and much more. |
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
|
|||
|
I am trying to retrieve data from MS Excel using ODBC and SQL. Everything works good except for date/time fields. I am seeing in the excel file a time fields like the following:
00:49:30 00:50:00 00:50:30 when I read them in to a timestamp field I get the following: 00:49:30 00:49:59 00:50:29 I appears I am losing some precision thru Excel or the ODBC driver. Does anyone have any experiance with this that can help? |
| Sponsored Links |
|
|
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Peculiar UI Problem Needs Tackling | adriyel | C# Programming | 2 | 04-06-2008 08:46 AM |
| [C] Comparison problem | Alhazred | C and C++ | 1 | 08-29-2007 05:58 AM |
| ODBC API - Special Table and Column Names | Tronman | Database & Database Programming | 0 | 07-30-2007 01:52 PM |
| Odbc Api | Tronman | Database & Database Programming | 3 | 05-03-2007 11:51 AM |
| A small problem in the output | The_Master | C and C++ | 3 | 12-13-2006 01:04 PM |
| WingedPanther | ........ | 2753.6 |
| Xav | ........ | 2704 |
| Brandon W | ........ | 1702.32 |
| John | ........ | 1207.73 |
| marwex89 | ........ | 1175.24 |
| morefood2001 | ........ | 966.05 |
| dcs | ........ | 655.75 |
| Steve.L | ........ | 475.59 |
| orjan | ........ | 418.58 |
| Aereshaa | ........ | 383.54 |