sqlite odbc 获取小时分钟。秒

Question

我正在使用 sqliteodbc ，由于某种原因，它无法获取小时、分钟和秒。我使用以下方式绑定列：

SQLBindCol(hTimeStampNotes, 5, SQL_C_TIMESTAMP, &(noteTimeStamp.submitTime), 16, &junkLong);

noteTimeStamp.submitTime 是一种时间戳数据类型：

typedef struct tagTimeStampType {//TIMESTAMP_STRUCT 
    short year;
    short month;
    short day;
    short hour;
    short minute;
    short second;
    unsigned int fraction; 
} TimeStampType;//TIMESTAMP_STRUCT;

我的小时、分钟、秒和分数始终显示为 0。这对我使用 access 数据库有效。还有其他人遇到过这个问题吗？一周前我就可以发誓这对我有用。

Answer 1

好吧，我不明白为什么会发生这种情况，我是这样解决的：

首先我在类型的末尾添加了一个数组

typedef struct tagTimeStampType//TIMESTAMP_STRUCT 
   {
   short year;
   short month;
   short day;
   short hour;
   short minute;
   short second;
   unsigned int fraction; 
   char  timeStampStr[20];
   } TimeStampType;//TIMESTAMP_STRUCT;

，然后添加了#ifdef

#ifdef SQLITE
   SQLBindCol(hTimeStampNotes, 5, SQL_C_CHAR, noteTimeStamp.submitTime.timeStampStr, 20, &junkLong);
#else
   SQLBindCol(hTimeStampNotes, 5, SQL_C_TIMESTAMP, &(noteTimeStamp.submitTime), 16, &junkLong);

，然后自己用一个小函数调整了字符串的速度，

void TimeStampPrep(TimeStampType *timeStamp)
{
#ifdef SQLITE
   timeStamp->year = atoi(timeStamp->timeStampStr);
   timeStamp->month = atoi(&(timeStamp->timeStampStr[5]));
   timeStamp->day = atoi(&(timeStamp->timeStampStr[8]));
   timeStamp->hour = atoi(&(timeStamp->timeStampStr[11]));
   timeStamp->minute = atoi(&(timeStamp->timeStampStr[14]));
   timeStamp->second = atoi(&(timeStamp->timeStampStr[17]));
   return;
#else
   return;
#endif
}

我仍在尝试弄清楚弄清楚为什么我的原始代码不能与 sqlite 一起使用。

Answer 2

几年过去了，但什么都没有改变:)

对于那些想知道实际原因的人：

...来自 sqlite3odbc.c

     if (p->coldef && p->coldef <= 16) {
         sprintf(p->strbuf, "%04d-%02d-%02d %02d:%02d:00.000",
                 ((TIMESTAMP_STRUCT *) p->param)->year,
                 ((TIMESTAMP_STRUCT *) p->param)->month,
                 ((TIMESTAMP_STRUCT *) p->param)->day,
                 ((TIMESTAMP_STRUCT *) p->param)->hour,
                 ((TIMESTAMP_STRUCT *) p->param)->minute);
     } else if (p->coldef && p->coldef <= 19) {
         sprintf(p->strbuf, "%04d-%02d-%02d %02d:%02d:%02d.000",
                 ((TIMESTAMP_STRUCT *) p->param)->year,
                 ((TIMESTAMP_STRUCT *) p->param)->month,
                 ((TIMESTAMP_STRUCT *) p->param)->day,
                 ((TIMESTAMP_STRUCT *) p->param)->hour,
                 ((TIMESTAMP_STRUCT *) p->param)->minute,
                 ((TIMESTAMP_STRUCT *) p->param)->second);
     } else {
         sprintf(p->strbuf, "%04d-%02d-%02d %02d:%02d:%02d.%03d",
                 ((TIMESTAMP_STRUCT *) p->param)->year,
                 ((TIMESTAMP_STRUCT *) p->param)->month,
                 ((TIMESTAMP_STRUCT *) p->param)->day,
                 ((TIMESTAMP_STRUCT *) p->param)->hour,
                 ((TIMESTAMP_STRUCT *) p->param)->minute,
                 ((TIMESTAMP_STRUCT *) p->param)->second,
                 len);
     }