Code covered by the BSD License  

Highlights from
DateStr2Num

4.91667

4.9 | 12 ratings Rate this file 38 Downloads (last 30 days) File Size: 9.76 KB File ID: #28093
image thumbnail

DateStr2Num

by

 

01 Jul 2010 (Updated )

Convert date string to date number - C-Mex: much faster than DATENUM

| Watch this File

File Information
Description

DATESTR2NUM - Fast conversion of DATESTR to DATENUM

The builtin DATENUM command is very powerful, but if the input is known to be valid and formatted exactly, a specific MEX can be much faster:
For single strings DateStr2Num is about 120 times faster than DATENUM, for a {1 x 10000} cell string, the speed up factor is 300 to 700(!), (Matlab 2011b/64, MSVC 2008).

D = DateStr2Num(S, F)
INPUT:
  S: String or cell string in DATESTR(F) format.
     In opposite to DATENUM the validity of the input string is *not* checked.
  F: Integer number defining the input format. Accepted:
        0: 'dd-mmm-yyyy HH:MM:SS' 01-Mar-2000 15:45:17
        1: 'dd-mmm-yyyy' 01-Mar-2000
       29: 'yyyy-mm-dd' 2000-03-01
       30: 'yyyymmddTHHMMSS' 20000301T154517
       31: 'yyyy-mm-dd HH:MM:SS' 2000-03-01 15:45:17
     1000: 'dd-mmm-yyyy HH:MM:SS.FFF' 01-Mar-2000 15:45:17.123
     1030: 'yyyymmddTHHMMSS.FFF' 20000301T154517.123
OUTPUT:
  D: Serial date number.

EXAMPLE:
  C = {'2010-06-29 21:59:13', '2010-06-29 21:59:13'};
  D = DateStr2Num(C, 31)
  >> [734318.916122685, 734318.916122685]
  Equivalent Matlab command (but a column vector is replied ever):
  D = datenum(C, 'yyyy-mm-dd HH:MM:SS')

The C-file must be compiled before using. See instructions in the help text.
Pre-compiled Mex files can be downloaded from: http://www.n-simon.de/mex

Tested: Matlab 6.5, 7.7, 7.8, 7.13, 32/64bit, WinXP/7
Compiler: LCC 2.4/3.8, BCC 5.5, Open Watcom 1.8, MSVC 2008
        Compatibility to MacOS, Linux, 64 bit is assumed, but not tested.

See also: DateConvert (Jan Simon)
  http://www.mathworks.com/matlabcentral/fileexchange/25594

MATLAB release MATLAB 7.8 (R2009a)
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
Comments and Ratings (19)
15 Aug 2014 Felipe  
02 Aug 2014 Jan Simon

@joh: What exactly is an "array of dates"? Cell strings are handles internally already.

30 Jul 2014 joh

hi, would you use a for loop for an array of dates?

19 Feb 2014 scott worland

Perfect! I am using 15 minute interval stream records --- my data sets are around 0.5 million lines (Elapsed time is 0.019273 seconds to convert dates to number using DateStr2Num)

25 Oct 2013 Jan Simon

@James: I do not understand the question. Of course I've created the C-file, before it could be compiled by the mex command.
I suggest to post the error you get form the compiler and explain the required details.

10 Oct 2013 James

Excellent work Jan! How did you create the c file before using the mex command? I keep getting errors from matlab compiler.

Thanks
-Jimmy

15 Apr 2013 Reza Farrahi Moghaddam  
25 Dec 2012 Hao Shen  
23 Jul 2012 Swasti Khuntia

Excellent stuff !!!!

17 Jun 2012 German Gomez-Herrero

Exactly what I was looking for! This is really good stuff

09 May 2012 Jonathan Sullivan

Very nice submission. It is enormously faster than datenum. Another great file from Jan.

24 Aug 2011 Jan Simon

To convert a serial date number to a '2011-08-24 23:38:44' date string:
sprintf('%.4d-%.2d-%.2d %.2d:%.2d:%.2d', datevecmx(now, 1));

06 Aug 2011 Saad

ignore my previous comment...the string had some trailing whitespace which was leading the c program to throw an exception.

06 Aug 2011 Saad

Hi, thanks for writing this, it works great. But it seems like the C compiled version doesn't accept a char string? I have a char string of 1x25 which works with the normal .m function but I get a warning that the format is not acceptable within the compiled version. I have to use the cellstr() function to convert, before passing to the compiled version. In the end, the run time between compiled and .m function are the same. Anyway you can adapt this?

22 Jul 2011 Todd

My bad. Like Nate, I figured it out - what a difference! The command:
mex -O DateStr2Num.c
Generated a DateStr2Num.mexw64 file and wham! My code was at 90s using datenum. Now that section takes 0.02s. Thanks!

07 Jul 2011 Nate Jensen

Sorry, I'm retarded, I figured it out.

07 Jul 2011 Nate Jensen

Good function, I use it all the time. I am retarded at C though. Could you tell me how to run the C function from Matlab? Thanks.

20 Apr 2011 Jan Simon

@Reyna: The new '300' format contains milliseconds also.

21 Mar 2011 Reyna

This is great. Is it possible to add millisec? Particularly to extend format 30 to yyyymmddTHHMMSS.FFF?

Updates
29 Mar 2011

New integer arithmetics for >50% more speed. Support of milliseconds in yyyymmddTHHMMSS.FFF format.

29 Jul 2013

New format "1000": dd-mmm-yyyy HH:MM:SS.FFF
Old format "300" called "1030" now.

Contact us