Note
ამ გვერდზე წვდომა ავტორიზაციას მოითხოვს. შეგიძლიათ სცადოთ შესვლა ან დირექტორიების შეცვლა.
ამ გვერდზე წვდომა ავტორიზაციას მოითხოვს. შეგიძლიათ სცადოთ დირექტორიების შეცვლა.
Applies to: 
Databricks SQL Databricks Runtime 18 and above
Note
Databricks Runtime 18 is newer than Databricks Runtime 18.0, 18.1, and 18.2. Features that would previously have shipped as a later numbered version now ship as dated updates to Databricks Runtime 18 instead. For details, see About unified release notes.
Returns time truncated to the unit specified in unit.
Syntax
time_trunc(unit, expr)
Arguments
unit: A STRING literal.expr: A TIME expression.
Returns
A TIME.
Valid units for unit are (case-insensitive):
'HOUR': Zero out the minute, second, and fraction parts.'MINUTE': Zero out the second and fraction parts.'SECOND': Zero out the fractional second part.'MILLISECOND': Zero out sub-millisecond fractions.'MICROSECOND': TIME values are stored at microsecond precision, so no sub-microsecond fractions exist to zero out. The value is unchanged.
Examples
> SELECT time_trunc('HOUR', TIME'13:08:15.123');
13:00:00
> SELECT time_trunc('MINUTE', TIME'13:08:15.123');
13:08:00
> SELECT time_trunc('SECOND', TIME'13:08:15.123456');
13:08:15
> SELECT time_trunc('MILLISECOND', TIME'13:08:15.123456');
13:08:15.123000