Welcome to WuJiGu Developer Q&A Community for programmer and developer-Open, Learning and Share
Ask a Question
Welcome To Ask or Share your Answers For Others

Categories

对DolphinDB表中的列做基于条件的计算

0 votes
240 views
in Technique[技术] by (71.8m points)

对DolphinDB表中的列做基于条件的计算

如果我有一个场景想对表中的列做基于条件的计算,我这样写可以吗？month1_20200319153450.png

但是结果和我想的不一样，如下图所示month2_20200319153501.png：


与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

month是把时间类型转换为MONTH类型，要得到月份的数字，需要用monthOfYear函数


与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
Welcome to WuJiGu Developer Q&A Community for programmer and developer-Open, Learning and Share

Just Browsing Browsing

2.1m questions

2.1m answers

62 comments

56.6k users

Most popular tags

Snow Theme by Q2A Market
Powered by Question2Answer
...