Converting yyyymmdd double to decimal year

Question

aaron Harvey 2016-2-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/268072-converting-yyyymmdd-double-to-decimal-year

评论： aaron Harvey 2016-2-15

Hi there, I have many variables made from doubles. I would like to plot certain variables against the date which is also made of doubles in the format yyyymmdd. So far i have:

function [out1] = simpleplot(variable,depthvar,mindepth,maxdepth,datevar,startdate,enddate,xlab,ylab);
depth = find(depthvar>mindepth & depthvar<maxdepth & ~isnan(variable));
datedepth=datevar(depth);
variable_depth=variable(depth);
plot(datedepth, variable_depth,'sk--')
xlabel(xlab);
ylabel(ylab);
axis([startdate enddate min(variable_depth) max(variable_depth)]);
end

However because my dates are yyyymmdd not in decimal year the plot has large gaps in it.

How can i convert the date doubles to decimal year within the function and also to have the x axis show date in a meaningful way like yy/mm rather than decimal year.

thank-you

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Guillaume 2016-2-14

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/268072-converting-yyyymmdd-double-to-decimal-year#answer_209816

编辑：Guillaume 2016-2-14

在 MATLAB Online 中打开

An alternative to the conversion to string and back, which is always going to be slow, is to divide and mod you date variable:

datevar = [19981020 19981023 19981203 1999011];
y = floor(datevar/10000);
m = floor(mod(datevar, 10000) / 100);
d = mod(datevar, 100);
datedepth = datetime(y, m, d);

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

aaron Harvey 2016-2-15

thank-you. this method works perfect and makes a lot more sense to me :)

请先登录，再进行评论。

Answer 2

Star Strider 2016-2-14

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/268072-converting-yyyymmdd-double-to-decimal-year#answer_209785

在 MATLAB Online 中打开

To get MATLAB date numbers from your date data, this works:

date_var = 20160214;
date_number = datenum(sprintf('%.0f', date_var), 'yyyymmdd');
Check = datestr(date_number)
Check =
14-Feb-2016

3 个评论
显示 1更早的评论隐藏 1更早的评论

Guillaume 2016-2-14

编辑：Guillaume 2016-2-14

在 MATLAB Online 中打开

You need to reshape the string into rows of dates and convert to cell array for datenum to work:

datenum(cellstr(reshape(sprintf('%d', datevar), 8, [])', 'yyyymmdd'))

Star Strider 2016-2-14

在 MATLAB Online 中打开

My pleasure.

I was illustrating the idea. To use my code on a column vector of double-precision dates, it needs to be tweaked a bit:

double_date_vec = [20160214:20160313]';                             % Column Vector Of Double-Precision Dates
date_number_fcn = @(double_dates) datenum(sprintf('%.0f\n', double_dates), 'yyyymmdd');
date_nums = arrayfun(date_number_fcn, double_date_vec);
Check = datestr(date_nums(1:20,:))                                  % Check Output (Can Be Deleted)

The date_nums array contains the datenum date numbers for all the dates in the ‘double_date_vec’ column vector. The arrayfun call does the background looping (much more efficiently than a for loop) necessary to apply the ‘date_number_fcn’ function to the vector of double-precision date variables. The MATLAB date and time functions do all the necessary conversions, including in this instance to allow for 2016 being a leap year.

I usually include ‘Check’ variables to illustrate that my code does what it needs to. Here, it prints 14-Feb-2016 to 04-Mar-2016 to the Command Window. You can discard that line.

请先登录，再进行评论。