Click here to Skip to main content
15,921,226 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: unicode woes Pin
cmk2-Sep-03 9:12
cmk2-Sep-03 9:12 
GeneralMultiple views and single document Pin
Binayak2-Sep-03 6:34
Binayak2-Sep-03 6:34 
GeneralRe: Multiple views and single document Pin
palbano2-Sep-03 7:25
palbano2-Sep-03 7:25 
GeneralVC++ / MSAccess Date Handling Pin
msdaug2-Sep-03 6:15
msdaug2-Sep-03 6:15 
GeneralRe: VC++ / MSAccess Date Handling Pin
palbano2-Sep-03 6:56
palbano2-Sep-03 6:56 
GeneralRe: VC++ / MSAccess Date Handling Pin
msdaug2-Sep-03 9:56
msdaug2-Sep-03 9:56 
GeneralRe: VC++ / MSAccess Date Handling Pin
msdaug2-Sep-03 14:10
msdaug2-Sep-03 14:10 
GeneralRe: VC++ / MSAccess Date Handling Pin
Steve S3-Sep-03 2:23
Steve S3-Sep-03 2:23 
You need to format your query time differently. You know it's implemented and stored as an 8-byte IEEE floating point, but Access won't admit it.
Try asking "SELECT id FROM tblSample WHERE dtTime = 'YYYY-MM-DD hh:mm:ss'" instead.
You can use VariantTimeToSystemTime to convert from the original value.

However, you should note that some databases (like SQL Server) will truncate at milliseconds, so it might be an idea to use VariantTimeToSystemTime, and convert back (SystemTimeToVariantTime), which ignores milliseconds, before inserting the value. This will prevent any off by a small fraction of a second errors.

Steve S
GeneralRe: VC++ / MSAccess Date Handling Pin
msdaug10-Sep-03 8:00
msdaug10-Sep-03 8:00 
GeneralHelp! Figure out whats wrong! FOR LOOP-ing! Pin
colormyiris2-Sep-03 5:50
colormyiris2-Sep-03 5:50 
GeneralRe: Help! Figure out whats wrong! FOR LOOP-ing! Pin
Ted Ferenc2-Sep-03 6:54
Ted Ferenc2-Sep-03 6:54 
GeneralRe: Help! Figure out whats wrong! FOR LOOP-ing! Pin
David Crow2-Sep-03 7:39
David Crow2-Sep-03 7:39 
GeneralRe: Help! Figure out whats wrong! FOR LOOP-ing! Pin
Ted Ferenc2-Sep-03 7:48
Ted Ferenc2-Sep-03 7:48 
GeneralRe: Help! Figure out whats wrong! FOR LOOP-ing! Pin
Andrew Allen2-Sep-03 10:10
Andrew Allen2-Sep-03 10:10 
GeneralRe: Help! Figure out whats wrong! FOR LOOP-ing! Pin
David Crow2-Sep-03 7:45
David Crow2-Sep-03 7:45 
GeneralI need a MMC expert Pin
YaronNir2-Sep-03 4:57
YaronNir2-Sep-03 4:57 
GeneralPlease explain this error message for me. T__T Pin
2-Sep-03 4:49
suss2-Sep-03 4:49 
GeneralRe: Please explain this error message for me. T__T Pin
Ian Darling2-Sep-03 5:03
Ian Darling2-Sep-03 5:03 
QuestionHow add aplication in Internet Explorer Rebar Pin
Denis A. Vergara2-Sep-03 4:48
Denis A. Vergara2-Sep-03 4:48 
QuestionGetTextMetrics results depends of text angle ? Pin
JP GOBLET2-Sep-03 4:35
JP GOBLET2-Sep-03 4:35 
Generalmemory allocation in C Pin
ravingcoder2-Sep-03 4:31
ravingcoder2-Sep-03 4:31 
GeneralRe: memory allocation in C Pin
hph2-Sep-03 4:35
hph2-Sep-03 4:35 
GeneralRe: memory allocation in C Pin
jason992-Sep-03 4:36
jason992-Sep-03 4:36 
GeneralRe: memory allocation in C Pin
Maximilien2-Sep-03 4:38
Maximilien2-Sep-03 4:38 
GeneralRe: memory allocation in C Pin
ravingcoder2-Sep-03 5:55
ravingcoder2-Sep-03 5:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.