[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Minor Success Story!

From: Clark Dunson
Subject: Minor Success Story!
Date: Tue, 10 Aug 2021 06:52:16 -0700

I have been on this and the maintainers list for more than a decade. Hello all.

Today I ran into trouble with datenum('2021-07-21 09:00:00.987'). The fractional part. But what I soon found is that this: datenum('2021-07-21 09:00:00.987','yyyy-mm-dd HH:MM:SS.FFF') works just fine. (This is of course a primary use case of those who would analyze SQL data.)

OK, so a lot of the time I spent waiting on Matlab to hunt and complete this conversion on some larger arrays, may have been significantly SHORTENED had I done it right in the first place!

(Thank you Octave)

Looking at datevec.m, none of the std_formats have FFF, so likely enhancing the search (though it works on Matlab) makes no sense. Does it? 



Microsoft SQL Server datetime format

reply via email to

[Prev in Thread] Current Thread [Next in Thread]