Fonctions de date et d'heure (Lakehouse v1)
Cette section fournit la référence des fonctions de date et d’heure de PlaidCloud Lakehouse.
Fonctions de conversion
Section intitulée « Fonctions de conversion »- 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