If I display this value under Query Analyzer like:
Convert(float, StartTime) = 0.0
In delphi I display as
FloatToStr(qryRunStartTime.value) = 2.0
Why is this ????
This is causing me problems elsewhere when I do comparisons.
Why is it different by 2.0 ?
The Delphi TDateTime interprets 0 as Dec 30, 1899 (there's your two days).
This was done to match COM apparently (and MS erred in COM, it would've made
more sense to make it the *last* day of the year instead of the second
However, if this is a date field in SQL Server, and you retrieve it as a
DateTime field, then this should be transparent to you. Why are you treating
it as a float?
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
Powered by Delphi and IB: http://www.logicfundamentals.com/RadBooks.html
"Democracy, without that guarantee of liberty, is merely a method of
selecting tyrants." - Alan Nitikman
I am adding 2 to the days to make equivalent.
I guess I should maybe have used the FloatToDateTime function ?
"Wayne Niddery [TeamB]" <wnid...@chaff.aci.on.ca> wrote in message
Get the field AsDateTime from the database and use DecodeTime to get