Mind map
ROUND & TRUNC [DATES]
Map content
ROUND & TRUNC [DATES]
- Fuente: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/ROUND-and-TRUNC-Date-Functions.html#GUID-8E10AB76-21DA-490F-A389-023B648DDEF8
Year
- SYYYY YYYY YEAR SYEAR YYY YY Y
ISO Year
- IYYY IY I
Quater
- Q
Month
- MONTH MON MM RM
Week
- WW
IW
- IW
W
- W
Day
- DDD DD J
Start Day of the Week
- DAY DY D
Hour
- HH HH12 HH24
Minute
- MI
Century
- CC SCC
Information
- Description
- SQL 18c OCA - OBJ 3 : Using Single-Row Functions to Customize Output
- Created by
- Adrian Mora
- Views
- 60
- Tags
- Rating