Timestream DAYNAME alternative to limit aggregation to weekdays

0

I am looking for an option to have aggregation over timeseries to be performed only for weekdays, like Monday, Tuesday and etc. I tried DAYNAME function but it doesn't seem to exist. Is there an alternative to that function or any other way to achieve what I am after?

Would be also interesting to find out how to get aggregation limited from 06:00 to 16:00 every day for example, but this might be a separate question.

hRed
質問済み 2年前277ビュー
1回答
1
承認された回答

The function day_of_week(<timestamp>) or the alias dow(<timestamp>) return the day of the week. These functions return an integer, the value ranges from 1 (Monday) to 7 (Sunday).

The function hour(<timestamp>) returns the hour of the day, the value ranges from 0 to 23.

AWS
回答済み 2年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ