日付と時刻の関数(Lakehouse v1)
このセクションでは、PlaidCloud Lakehouse の日時関連関数のリファレンス情報を提供します。
- DATE
- TO_MONTH
- MONTH
- TO_DATE
- TO_DATETIME
- TODAY
- TO_DAY_OF_MONTH
- DAY
- TO_DAY_OF_WEEK
- TO_DAY_OF_YEAR
- TO_HOUR
- TO_MINUTE
- TO_MONDAY
- TOMORROW
- TO_QUARTER
- QUARTER
- TO_SECOND
- TO_START_OF_DAY
- TO_START_OF_FIFTEEN_MINUTES
- TO_START_OF_FIVE_MINUTES
- TO_START_OF_HOUR
- TO_START_OF_ISO_YEAR
- TO_START_OF_MINUTE
- TO_START_OF_MONTH
- TO_START_OF_QUARTER
- TO_START_OF_SECOND
- TO_START_OF_TENMINUTES
- TO_START_OF_WEEK
- TO_START_OF_YEAR
- TOTIMESTAMP
- TO_UNIX_TIMESTAMP
- TO_WEEK_OF_YEAR
- WEEK
- WEEKOFYEAR
- TO_YEAR
- YEAR
- TO_YYYYMM
- TO_YYYYMMDD
- TO_YYYYMMDDHH
- TO_YYYYMMDDHHMMSS
- STR_TO_DATE
- STR_TO_TIMESTAMP
- TRY_TO_DATETIME
- TRY_TO_TIMESTAMP