strctodt#

Purpose#

Converts string dates to a matrix containing dates in DT Scalar date/time format, using the BSD strftime format specifiers.

Format#

d = strctodt(x, fmt)#

Parameters:

x (NxK string array) – dates
fmt (string or or ExE conformable string array) – containing strftime date/time format characters.

Returns:

d (NxK matrix) – containing dates in DT Scalar format (i.e. 200803170930).

Examples#

Example 1#

print strctodt("2012/06/23", "%Y/%m/%d");

produces the output:

20120623000000

Example 2#

print strctodt("1945-11-22 18:36:29", "%Y-%m-%d %H:%M:%S");

produces the output:

19451122183629

Example 3#

print strctodt("January 29, 1973 at  4:19 PM", "%B %d, %Y at %l:%M %p");

produces the output:

19730129161900

Example 4#

ds = "Oct 23, 2007" $| "Feb 16, 2008";
s = strctodt(ds, "%b %d, %Y");

produces s equal to:

20071023000000
20080216000000

Example 5#

ds = "10/23/07 20:45:42" $| "02/16/08 14:32:22";
s = strctodt(ds, "%x %X");

produces s equal to:

20071023204542
20080216143222

Remarks#

The following format specifiers are supported:

%A	The full weekday name.
%a	The abbreviated weekday name.
%B	The full month name.
%b, or %h	The abbreviated month name.
%C	The century (a year divided by 100 and truncated to an integer) as a decimal number (00-99).
%c	The locale’s appropriate date and time representation.
%D	The date format “%m/%d/%y”.
%d	The day of month as a decimal number (01-31).
%e	The day of month as a decimal number (1-31); single digits are preceded by a blank.
%F	The date format “%Y-%m-%d”.
%G	The ISO 8601 year with century as a decimal number.
%g	The ISO 8601 year without century as a decimal number (00-99).
%H	The hour (24-hour clock) as a decimal number (00-23).
%I	The hour (12-hour clock) as a decimal number (01-12).
%j	The day of the year as a decimal number (001-366).
%k	The hour (24-hour clock) as a decimal number (0-23); single digits are preceded by a blank.
%l	The hour (12-hour clock) as a decimal number (1-12); single digits are preceded by a blank.
%M	The minute as a decimal number (00-59).
%m	The month as a decimal number (01-12).
%n	A newline.
%p	The locale’s equivalent of either “AM” or “PM”.
%R	The time in the format “%H:%M”.
%r	The locale’s representation of 12-hour clock time using AM/PM notation.
%S	The second as a decimal number (00-60). The range of seconds is (00-60) instead of (00-59) to allow for the periodic occurrence of leap seconds.
%s	The number of seconds since the Epoch, UTC.
%T	The time in the format “%H:%M:%S”.
%t	A tab.
%U	The week number of the year (Sunday as the first day of the week) as a decimal number (00-53).
%u	The weekday (Monday as the first day of the week) as a decimal number (1-7).
%V	The week number of the year (Monday as the first day of the week) as a decimal number (01-53). If the week containing January 1 has four or more days in the new year, then it is week 1; otherwise it is week 53 of the previous year, and the next week is week 1.
%v	The date in the format “%e-%b-%Y”.
%W	The week number of the year (Monday as the first day of the week) as a decimal number (00-53).
%w	The weekday (Sunday as the first day of the week) as a decimal number (0-6).
%X	The locale’s appropriate time representation.
%x	The locale’s appropriate date representation.
%Y	The year with century as a decimal number.
%y	The year without century as a decimal number (00-99).
%Z	The time zone name, or by the empty string if this is not determinable.
%%	The ‘%’ sign.