On Tue, Aug 26, 2008 at 2:07 PM, Grant Limberg <[EMAIL PROTECTED]> wrote:
> On Aug 26, 2008, at 8:40 AM, Baron Schwartz wrote:
>
>> On Tue, Aug 26, 2008 at 11:23 AM, Grant Limberg <[EMAIL PROTECTED]>
>> wrote:
>>>
>>> Any thoughts on supporting milliseconds in DATETIME fields?  In my
>>> professional line of work, I've run across several situations in the
>>> analysis of aircraft flight tracks where radar systems have a millisecond
>>> resolution.  On MySQL I've always had to break the datetime provided by
>>> the
>>> radar systems into two fields, one datetime, and one integer in order to
>>> hold on to the millisecond data.  My preferred solution would be to have
>>> the
>>> data stored in the DATETIME field itself.  I haven't dug into the
>>> DATETIME
>>> data type code yet, but it shouldn't be too incredibly difficult to
>>> implement.  Does anyone else see this as a useful feature?
>>
>> Yes.  And microseconds, too.  Nanoseconds?
>
> Sure.  We'll throw in the kitchen sink while we're at it :)
>

Well, microseconds are easy, but I'm not sure about nanoseconds,
especially cross-platform :)

Baron

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to