Hi all,
I have a column vector with dates formatted yyyymm. Originally, this vector printed as yyyymm.00, but I changed the format using the format command and now it prints as yyyymm. I've been trying to set this as a date variable, but the dttostr command returns a vector in which each entry reads "0000-00", dttodtv returns an eight-column matrix whose first row is "-1 11 30 20 6 7 3 333" (the first entry in the column vector of dates is "200607"), and dtvtodt returns an error G0036: matrices are not conformable. How are my date values formatted, and how can I change them to a format I can work with?
5 Answers
0
Try this code snippet here:
//July of 2006 through January of 2007 d = { 200607, 200608, 200609, 200610, 200611, 200612, 200701 }; date_str = dttostr(d, "YYYY-MO"); print date_str;
In GAUSS 15 I get this output, which I think is what you want:
2006-07 2006-08 2006-09 2006-10 2006-11 2006-12 2007-01
0
0
OK, I think in version 12 or 13 is when GAUSS first allowed these scalar numeric dates (DT Scalar Format) to have as fewer than 14 digits before the decimal place. The full DT Scalar is: year, month, day, hour, minute, second, like this:
YYYYMODDHHMISS YYYY -> Year MO -> Month DD -> Day HH -> Hour MI -> Minute SS -> Second
For a specific example: October, 24th 2015 at 8:45 am would be:
20151024084500
GAUSS 10 requires you to include all 14 digits. Current versions of GAUSS only require you to specify the first 4 digits for the year and anything after that is optional. So for GAUSS 10, you need to change the original example to this:
//July of 2006 through January of 2007 d = { 200607, 200608, 200609, 200610, 200611, 200612, 200701 }; //Adjustment to 'full dtscalar format' for GAUSS 10 d = d * 1e8; date_str = dttostr(d, "YYYY-MO"); print date_str;
Your Answer
5 Answers
Try this code snippet here:
//July of 2006 through January of 2007 d = { 200607, 200608, 200609, 200610, 200611, 200612, 200701 }; date_str = dttostr(d, "YYYY-MO"); print date_str;
In GAUSS 15 I get this output, which I think is what you want:
2006-07 2006-08 2006-09 2006-10 2006-11 2006-12 2007-01
OK, I think in version 12 or 13 is when GAUSS first allowed these scalar numeric dates (DT Scalar Format) to have as fewer than 14 digits before the decimal place. The full DT Scalar is: year, month, day, hour, minute, second, like this:
YYYYMODDHHMISS YYYY -> Year MO -> Month DD -> Day HH -> Hour MI -> Minute SS -> Second
For a specific example: October, 24th 2015 at 8:45 am would be:
20151024084500
GAUSS 10 requires you to include all 14 digits. Current versions of GAUSS only require you to specify the first 4 digits for the year and anything after that is optional. So for GAUSS 10, you need to change the original example to this:
//July of 2006 through January of 2007 d = { 200607, 200608, 200609, 200610, 200611, 200612, 200701 }; //Adjustment to 'full dtscalar format' for GAUSS 10 d = d * 1e8; date_str = dttostr(d, "YYYY-MO"); print date_str;