================================================================================================
datetime +/- interval
================================================================================================

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
datetime +/- interval:                    Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date + interval(m)                                  823            851          46         12.1          82.3       1.0X
date + interval(m, d)                               793            798           5         12.6          79.3       1.0X
date + interval(m, d, ms)                          3512           3548          51          2.8         351.2       0.2X
date - interval(m)                                  788            803          13         12.7          78.8       1.0X
date - interval(m, d)                               815            818           4         12.3          81.5       1.0X
date - interval(m, d, ms)                          3523           3526           3          2.8         352.3       0.2X
timestamp + interval(m)                            1793           1799           9          5.6         179.3       0.5X
timestamp + interval(m, d)                         1840           1841           2          5.4         184.0       0.4X
timestamp + interval(m, d, ms)                     1935           1942           9          5.2         193.5       0.4X
timestamp - interval(m)                            1699           1711          17          5.9         169.9       0.5X
timestamp - interval(m, d)                         1745           1755          13          5.7         174.5       0.5X
timestamp - interval(m, d, ms)                     1927           1932           7          5.2         192.7       0.4X


================================================================================================
Extract components
================================================================================================

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
cast to timestamp:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
cast to timestamp wholestage off                    200            203           5         50.0          20.0       1.0X
cast to timestamp wholestage on                     189            199           7         52.9          18.9       1.1X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
year of timestamp:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
year of timestamp wholestage off                    619            620           1         16.2          61.9       1.0X
year of timestamp wholestage on                     603            610           7         16.6          60.3       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
quarter of timestamp:                     Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
quarter of timestamp wholestage off                 651            653           4         15.4          65.1       1.0X
quarter of timestamp wholestage on                  640            644           4         15.6          64.0       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
month of timestamp:                       Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
month of timestamp wholestage off                   625            626           1         16.0          62.5       1.0X
month of timestamp wholestage on                    621            628           7         16.1          62.1       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
weekofyear of timestamp:                  Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
weekofyear of timestamp wholestage off              879            881           4         11.4          87.9       1.0X
weekofyear of timestamp wholestage on               939            945           9         10.7          93.9       0.9X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
day of timestamp:                         Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
day of timestamp wholestage off                     638            640           4         15.7          63.8       1.0X
day of timestamp wholestage on                      622            629           5         16.1          62.2       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
dayofyear of timestamp:                   Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
dayofyear of timestamp wholestage off               661            661           1         15.1          66.1       1.0X
dayofyear of timestamp wholestage on                647            654          12         15.4          64.7       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
dayofmonth of timestamp:                  Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
dayofmonth of timestamp wholestage off              648            659          16         15.4          64.8       1.0X
dayofmonth of timestamp wholestage on               622            624           2         16.1          62.2       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
dayofweek of timestamp:                   Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
dayofweek of timestamp wholestage off               762            770          11         13.1          76.2       1.0X
dayofweek of timestamp wholestage on                751            764          15         13.3          75.1       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
weekday of timestamp:                     Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
weekday of timestamp wholestage off                 737            739           2         13.6          73.7       1.0X
weekday of timestamp wholestage on                  717            719           2         13.9          71.7       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
hour of timestamp:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
hour of timestamp wholestage off                    601            616          22         16.6          60.1       1.0X
hour of timestamp wholestage on                     581            584           5         17.2          58.1       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
minute of timestamp:                      Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
minute of timestamp wholestage off                  612            617           7         16.3          61.2       1.0X
minute of timestamp wholestage on                   571            578           5         17.5          57.1       1.1X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
second of timestamp:                      Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
second of timestamp wholestage off                  609            610           2         16.4          60.9       1.0X
second of timestamp wholestage on                   581            584           2         17.2          58.1       1.0X


================================================================================================
Current date and time
================================================================================================

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
current_date:                             Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
current_date wholestage off                         184            208          35         54.4          18.4       1.0X
current_date wholestage on                          184            191           8         54.3          18.4       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
current_timestamp:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
current_timestamp wholestage off                    184            186           2         54.3          18.4       1.0X
current_timestamp wholestage on                     200            208           9         49.9          20.0       0.9X


================================================================================================
Date arithmetic
================================================================================================

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
cast to date:                             Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
cast to date wholestage off                         592            593           0         16.9          59.2       1.0X
cast to date wholestage on                          579            583           4         17.3          57.9       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
last_day:                                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
last_day wholestage off                             653            657           6         15.3          65.3       1.0X
last_day wholestage on                              639            645           8         15.7          63.9       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
next_day:                                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
next_day wholestage off                             612            613           1         16.3          61.2       1.0X
next_day wholestage on                              605            610           6         16.5          60.5       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
date_add:                                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_add wholestage off                             583            592          13         17.2          58.3       1.0X
date_add wholestage on                              567            571           7         17.6          56.7       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
date_sub:                                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_sub wholestage off                             578            580           2         17.3          57.8       1.0X
date_sub wholestage on                              561            567           6         17.8          56.1       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
add_months:                               Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
add_months wholestage off                           797            799           3         12.5          79.7       1.0X
add_months wholestage on                            782            796          14         12.8          78.2       1.0X


================================================================================================
Formatting dates
================================================================================================

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
format date:                              Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
format date wholestage off                         3040           3050          14          3.3         304.0       1.0X
format date wholestage on                          2974           2989          26          3.4         297.4       1.0X


================================================================================================
Formatting timestamps
================================================================================================

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
from_unixtime:                            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
from_unixtime wholestage off                       2812           2818           9          3.6         281.2       1.0X
from_unixtime wholestage on                        2818           2822           4          3.5         281.8       1.0X


================================================================================================
Convert timestamps
================================================================================================

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
from_utc_timestamp:                       Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
from_utc_timestamp wholestage off                   721            722           1         13.9          72.1       1.0X
from_utc_timestamp wholestage on                    774            782           6         12.9          77.4       0.9X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
to_utc_timestamp:                         Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
to_utc_timestamp wholestage off                     903            903           0         11.1          90.3       1.0X
to_utc_timestamp wholestage on                      932            938           5         10.7          93.2       1.0X


================================================================================================
Intervals
================================================================================================

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
cast interval:                            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
cast interval wholestage off                        221            225           6         45.3          22.1       1.0X
cast interval wholestage on                         216            223           9         46.2          21.6       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
datediff:                                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
datediff wholestage off                             965            966           0         10.4          96.5       1.0X
datediff wholestage on                              951            954           2         10.5          95.1       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
months_between:                           Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
months_between wholestage off                      3070           3073           3          3.3         307.0       1.0X
months_between wholestage on                       3115           3121           4          3.2         311.5       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
window:                                   Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
window wholestage off                               525            534          13          1.9         525.0       1.0X
window wholestage on                                664            669           4          1.5         663.6       0.8X


================================================================================================
Truncation
================================================================================================

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
date_trunc YEAR:                          Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc YEAR wholestage off                      760            762           3         13.2          76.0       1.0X
date_trunc YEAR wholestage on                       723            727           5         13.8          72.3       1.1X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
date_trunc YYYY:                          Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc YYYY wholestage off                      759            762           4         13.2          75.9       1.0X
date_trunc YYYY wholestage on                       725            731           8         13.8          72.5       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
date_trunc YY:                            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc YY wholestage off                        759            759           0         13.2          75.9       1.0X
date_trunc YY wholestage on                         722            727           7         13.8          72.2       1.1X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
date_trunc MON:                           Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc MON wholestage off                       755            756           2         13.2          75.5       1.0X
date_trunc MON wholestage on                        712            715           3         14.0          71.2       1.1X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
date_trunc MONTH:                         Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc MONTH wholestage off                     754            761          10         13.3          75.4       1.0X
date_trunc MONTH wholestage on                      711            714           5         14.1          71.1       1.1X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
date_trunc MM:                            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc MM wholestage off                        756            758           3         13.2          75.6       1.0X
date_trunc MM wholestage on                         717            724           7         13.9          71.7       1.1X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
date_trunc DAY:                           Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc DAY wholestage off                       628            628           1         15.9          62.8       1.0X
date_trunc DAY wholestage on                        589            592           3         17.0          58.9       1.1X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
date_trunc DD:                            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc DD wholestage off                        623            624           2         16.1          62.3       1.0X
date_trunc DD wholestage on                         592            600           8         16.9          59.2       1.1X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
date_trunc HOUR:                          Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc HOUR wholestage off                      630            632           2         15.9          63.0       1.0X
date_trunc HOUR wholestage on                       590            594           5         17.0          59.0       1.1X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
date_trunc MINUTE:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc MINUTE wholestage off                    628            629           1         15.9          62.8       1.0X
date_trunc MINUTE wholestage on                     581            582           2         17.2          58.1       1.1X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
date_trunc SECOND:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc SECOND wholestage off                    327            328           1         30.6          32.7       1.0X
date_trunc SECOND wholestage on                     283            285           2         35.3          28.3       1.2X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
date_trunc WEEK:                          Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc WEEK wholestage off                      694            694           0         14.4          69.4       1.0X
date_trunc WEEK wholestage on                       645            650           7         15.5          64.5       1.1X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
date_trunc QUARTER:                       Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc QUARTER wholestage off                   880            881           2         11.4          88.0       1.0X
date_trunc QUARTER wholestage on                    842            847           3         11.9          84.2       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
trunc year:                               Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
trunc year wholestage off                           771            772           2         13.0          77.1       1.0X
trunc year wholestage on                            733            737           4         13.6          73.3       1.1X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
trunc yyyy:                               Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
trunc yyyy wholestage off                           771            772           1         13.0          77.1       1.0X
trunc yyyy wholestage on                            736            740           4         13.6          73.6       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
trunc yy:                                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
trunc yy wholestage off                             779            782           5         12.8          77.9       1.0X
trunc yy wholestage on                              734            737           3         13.6          73.4       1.1X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
trunc mon:                                Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
trunc mon wholestage off                            736            736           1         13.6          73.6       1.0X
trunc mon wholestage on                             692            698           4         14.4          69.2       1.1X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
trunc month:                              Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
trunc month wholestage off                          736            738           2         13.6          73.6       1.0X
trunc month wholestage on                           695            703           8         14.4          69.5       1.1X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
trunc mm:                                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
trunc mm wholestage off                             738            740           3         13.6          73.8       1.0X
trunc mm wholestage on                              695            697           2         14.4          69.5       1.1X


================================================================================================
Parsing
================================================================================================

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
to timestamp str:                         Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
to timestamp str wholestage off                     110            114           5          9.1         109.7       1.0X
to timestamp str wholestage on                      119            122           2          8.4         119.5       0.9X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
to_timestamp:                             Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
to_timestamp wholestage off                         667            678          15          1.5         667.1       1.0X
to_timestamp wholestage on                          676            679           2          1.5         675.9       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
to_unix_timestamp:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
to_unix_timestamp wholestage off                    676            677           1          1.5         676.5       1.0X
to_unix_timestamp wholestage on                     672            675           3          1.5         672.1       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
to date str:                              Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
to date str wholestage off                          166            167           1          6.0         166.1       1.0X
to date str wholestage on                           162            164           3          6.2         162.5       1.0X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
to_date:                                  Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
to_date wholestage off                              701            701           1          1.4         700.6       1.0X
to_date wholestage on                               699            701           1          1.4         699.2       1.0X


================================================================================================
Conversion from/to external types
================================================================================================

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1020-azure
Intel(R) Xeon(R) Platinum 8370C CPU @ 2.80GHz
To/from Java's date-time:                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
From java.sql.Date                                  322            331           8         15.5          64.5       1.0X
From java.time.LocalDate                            240            242           2         20.8          48.1       1.3X
Collect java.sql.Date                              1499           1536          56          3.3         299.9       0.2X
Collect java.time.LocalDate                        1138           1259         134          4.4         227.6       0.3X
From java.sql.Timestamp                             228            248          19         21.9          45.6       1.4X
From java.time.Instant                              207            224          16         24.2          41.4       1.6X
Collect longs                                      1093           1247         142          4.6         218.6       0.3X
Collect java.sql.Timestamp                         1289           1398         111          3.9         257.8       0.3X
Collect java.time.Instant                          1044           1310         371          4.8         208.9       0.3X
java.sql.Date to Hive string                       4914           5126         191          1.0         982.7       0.1X
java.time.LocalDate to Hive string                 3469           3635         146          1.4         693.8       0.1X
java.sql.Timestamp to Hive string                  7043           7066          22          0.7        1408.5       0.0X
java.time.Instant to Hive string                   4376           4525         133          1.1         875.2       0.1X


