starrocks icon indicating copy to clipboard operation
starrocks copied to clipboard

date_format 函数问题

Open yqzdy1207 opened this issue 2 years ago • 4 comments

SR version : 3.0.2 select date_format(date_sub(current_date(),1),'yyyy-MM');

只是返回了 yyyy-MM、不是期望数据值

yqzdy1207 avatar Aug 02 '23 07:08 yqzdy1207

select last_day(current_date()); 直接报错了

yqzdy1207 avatar Aug 02 '23 07:08 yqzdy1207

日期格式必须带%,示例:select date_format(date_sub(current_date(),1),'%Y-%m');

jackqh avatar Aug 07 '23 10:08 jackqh

select last_day(current_date()); 直接报错了

Give more information please. It's correct for me.

And, so it's not a problem for the issue?

jaogoy avatar Aug 25 '23 06:08 jaogoy

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!

github-actions[bot] avatar Feb 26 '24 11:02 github-actions[bot]