Lost Password?


Go Back   CodeCall Programming Forum > Software Development > C and C++

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.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-10-2007, 03:31 PM
MarkWasik MarkWasik is offline
Newbie
 
Join Date: Apr 2007
Posts: 1
Rep Power: 0
MarkWasik is on a distinguished road
Default ODBC with VS C++ 6 Problem

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?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

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


All times are GMT -5. The time now is 03:07 AM.

Contest Stats

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

Contest Rules

CodeCall Goal

Goal: 100,000 Posts
Complete: 100%


Complete - Celebrate!

Ads