Re: Milliseconds to SQL Server DateTime

From: "John Herbster" <herb-sci1_at_sbcglobal.net>
Date: Fri, 7 Dec 2007 22:19:51 -0600

"Jouni Aro" <jouni.aro@xxxxxxxxx> wrote

I have now adopted the 'float' way and casting the values to
datetime in select. I will need to instruct the users also
to
cast

Jouni,

I presume, by "cast", that you mean convert from one binary
form to another

the data, if they need to add their own queries to the data.
...

I hope that you are aware that the TDateTime float type cannot
accurately represent millisecond times. That type can be very
close, but not exact.

Rgds, JohnH

.

Follow-Ups:
- Re: Milliseconds to SQL Server DateTime
  - From: Jouni Aro

Prev by Date: Re: Finding a record number using SQL
Next by Date: Re: Query based on the results of another query?
Previous by thread: Finding a record number using SQL
Next by thread: Re: Milliseconds to SQL Server DateTime
Index(es):
- Date
- Thread

Relevant Pages

Re: Polymorphism
... If this is the reason, ... your post you say "I presume the reason is that the type to cast to is not ... not compile time. ...
(comp.lang.java.programmer)
Re: Class.cast(Object) - what benefit?
... >When you construct a class with generic parameter T, ... You can then do the cast with both static and dynamic ... Is there ANY run time code that protects a typed ArrayList from ... I presume the compiler inserts these after a get ...
(comp.lang.java.programmer)