Re: Milliseconds to SQL Server DateTime

Joe Griffin wrote:
Jouni Aro wrote:

If no, what do you suggest?

In one of my programs, I needed this level of resolution, so store the TDateTime and also put the milliseconds into a separate smallint field. It's a bit cumbersome, but works.

Thanks for that tip as well! However, I am not willing to go that path :)

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 the data, if they need to add their own queries to the data. Anyway, it seems to be the only thing that can work simply and well enough in my application.

Thanks everyone for you suggestions.
.

Relevant Pages