Re: CADORecordBinding ... adDate

> So, speaking from and OLE DB perspective, which is where I am when I do
> think kind of binding ... what data type is this value? I'm using double

Right choice. DateTime is (educated guess) is using Excel's Dublin Julian
format.
See
http://en.wikipedia.org/wiki/Julian_day_number
and search for "Dublin" on web page

Whole numbers are the number of days.
Fractional numbers are the time out of a 24 hour day.
0.0 is 30/Dec/1899
1.0 is 31/Dec/1899
2.0 is 1/Jan/1900
3.0 is 2/Jan/1900
4.0 is 3/Jan/1900
and so on
0.0 is 00:00:00 on 24 hour clock
0.5 is 12:00:00 on 24 hour clock
0.25 is 06:00:00 on 24 hour clock
0.75 is 18:00:00 on 24 hour clock
0.10 is 02.24:00 on 24 hour clock
and so on.

> right now but am only guessing. And then, when OLE DB gives me this value,
> what can I use to convert this to either a SYSTEMTIME or FILETIME?

VariantTimetoSystemTime()
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/automat/html/d9d69521-9b33-4fc5-8a1c-929f216db450.asp

Why are you having to guess?
Forget about RecordBinding for a moment and just build a RecordSet
from SELECT TOP 1 yourdatetimefield FROM SomeTable
Now go and dump the Recordset and see what the Field Type is.
You should be able to stop guessing. It is probably adDate or adDBTimeStamp

Stephen Howe


.