Sqlite3 时间格式定制 毫秒数 两位小数

1. #include < ctime >
2. #include <sys/time.h>
5. struct timeval tv;
6. char buf2[64];
8. gettimeofday(&tv, NULL);
9. char buf[128] = {0};
10. strftime(buf2, sizeof (buf)-1, “%Y%m%d%H%M%S”, localtime (&tv.tv_sec));
11. sprintf(buf, “%s.%02d”, buf2, (int)(tv.tv_usec / 1000/10));
12. string Time(buf);
13. char msdate[10];
14. char msh[3];
15. char msm[3];
16. char mss[3];
17. char msms[3];
19. string DateTime;
20. sprintf(msdate,”%02d”,Date);
21. DateTime. append (msdate);
22. sprintf(msh,”%02d”,Hour);
23. DateTime.append(msh);
24. sprintf(msm,”%02d”, Minute );
25. DateTime.append(msm);
26. sprintf(mss,”%02d”,.Second);
27. DateTime.append(mss);

YYYYMMDDTHHMMSSSS