strtodt

Purpose

Converts a string array of dates to a matrix in DT scalar format.

Format

x = strtodt(sa, fmt)
Parameters:
  • sa (NxK string array) – dates
  • fmt (string) – date/time format characters
Returns:

x (NxK matrix) – dates in DT scalar format.

Examples

x = strtodt("2012-07-12 10:18:32", "YYYY-MO-DD HH:MI:SS");
print x;

produces:

20120712101832.0
x = strtodt("2012-07-12 10:18:32", "YYYY-MO-DD");
print x;

produces:

20120712000000.0
x = strtodt("10:18:32", "HH:MI:SS");
print x;

produces:

101832.0
x = strtodt("05-28-10", "MO-DD-YR");
print x;

produces:

20100528000000.0

Remarks

The DT scalar format is a double precision representation of the date and time. In the DT scalar format, the number:

20120921223505

represents 22:35:05 or 10:35:05 PM on September 21, 2012.

The following formats are supported:

YYYY Four digit year
YR Last two digits of year
QQ Quarters, Q1
MO Number of month, 01-12
DD Day of month, 01-31
HH Hour of day, 00-23
MI Minute of hour, 00-59
SS Second of minute, 00-59

See also

Functions dttostr(), dttoutc(), utctodt()