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

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
datetime +/- interval:                    Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date + interval(m)                                  737            781          66         13.6          73.7       1.0X
date + interval(m, d)                               738            742           6         13.6          73.8       1.0X
date + interval(m, d, ms)                          2887           2902          21          3.5         288.7       0.3X
date - interval(m)                                  709            716           7         14.1          70.9       1.0X
date - interval(m, d)                               713            719           5         14.0          71.3       1.0X
date - interval(m, d, ms)                          2908           2914           8          3.4         290.8       0.3X
timestamp + interval(m)                            1457           1458           2          6.9         145.7       0.5X
timestamp + interval(m, d)                         1476           1476           0          6.8         147.6       0.5X
timestamp + interval(m, d, ms)                     1562           1564           3          6.4         156.2       0.5X
timestamp - interval(m)                            1397           1401           5          7.2         139.7       0.5X
timestamp - interval(m, d)                         1442           1446           5          6.9         144.2       0.5X
timestamp - interval(m, d, ms)                     1564           1566           3          6.4         156.4       0.5X


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

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
cast to timestamp:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
cast to timestamp wholestage off                    169            169           1         59.3          16.9       1.0X
cast to timestamp wholestage on                     176            178           2         56.9          17.6       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
year of timestamp:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
year of timestamp wholestage off                    525            538          18         19.0          52.5       1.0X
year of timestamp wholestage on                     533            539           7         18.8          53.3       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
quarter of timestamp:                     Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
quarter of timestamp wholestage off                 556            558           2         18.0          55.6       1.0X
quarter of timestamp wholestage on                  565            567           2         17.7          56.5       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
month of timestamp:                       Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
month of timestamp wholestage off                   543            547           6         18.4          54.3       1.0X
month of timestamp wholestage on                    550            551           1         18.2          55.0       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
weekofyear of timestamp:                  Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
weekofyear of timestamp wholestage off              775            782           9         12.9          77.5       1.0X
weekofyear of timestamp wholestage on               854            856           2         11.7          85.4       0.9X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
day of timestamp:                         Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
day of timestamp wholestage off                     551            552           2         18.1          55.1       1.0X
day of timestamp wholestage on                      553            562          15         18.1          55.3       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
dayofyear of timestamp:                   Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
dayofyear of timestamp wholestage off               568            570           3         17.6          56.8       1.0X
dayofyear of timestamp wholestage on                581            584           2         17.2          58.1       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
dayofmonth of timestamp:                  Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
dayofmonth of timestamp wholestage off              563            597          48         17.8          56.3       1.0X
dayofmonth of timestamp wholestage on               555            562          11         18.0          55.5       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
dayofweek of timestamp:                   Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
dayofweek of timestamp wholestage off               674            675           1         14.8          67.4       1.0X
dayofweek of timestamp wholestage on                677            684           6         14.8          67.7       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
weekday of timestamp:                     Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
weekday of timestamp wholestage off                 628            629           1         15.9          62.8       1.0X
weekday of timestamp wholestage on                  637            643          11         15.7          63.7       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
hour of timestamp:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
hour of timestamp wholestage off                    509            509           0         19.7          50.9       1.0X
hour of timestamp wholestage on                     514            519           8         19.5          51.4       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
minute of timestamp:                      Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
minute of timestamp wholestage off                  516            517           1         19.4          51.6       1.0X
minute of timestamp wholestage on                   514            517           4         19.5          51.4       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
second of timestamp:                      Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
second of timestamp wholestage off                  511            512           1         19.6          51.1       1.0X
second of timestamp wholestage on                   516            521           3         19.4          51.6       1.0X


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

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
current_date:                             Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
current_date wholestage off                         150            150           0         66.6          15.0       1.0X
current_date wholestage on                          177            181           4         56.4          17.7       0.8X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
current_timestamp:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
current_timestamp wholestage off                    165            175          15         60.7          16.5       1.0X
current_timestamp wholestage on                     184            192          10         54.4          18.4       0.9X


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

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
cast to date:                             Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
cast to date wholestage off                         503            504           1         19.9          50.3       1.0X
cast to date wholestage on                          508            515          12         19.7          50.8       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
last_day:                                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
last_day wholestage off                             566            568           3         17.7          56.6       1.0X
last_day wholestage on                              591            593           2         16.9          59.1       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
next_day:                                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
next_day wholestage off                             541            552          16         18.5          54.1       1.0X
next_day wholestage on                              544            546           3         18.4          54.4       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
date_add:                                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_add wholestage off                             494            499           8         20.2          49.4       1.0X
date_add wholestage on                              510            517          10         19.6          51.0       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
date_sub:                                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_sub wholestage off                             495            499           6         20.2          49.5       1.0X
date_sub wholestage on                              509            514           6         19.7          50.9       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
add_months:                               Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
add_months wholestage off                           692            692           0         14.5          69.2       1.0X
add_months wholestage on                            696            706          15         14.4          69.6       1.0X


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

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
format date:                              Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
format date wholestage off                         2342           2346           6          4.3         234.2       1.0X
format date wholestage on                          2349           2357          12          4.3         234.9       1.0X


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

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
from_unixtime:                            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
from_unixtime wholestage off                       2054           2055           1          4.9         205.4       1.0X
from_unixtime wholestage on                        2089           2096           9          4.8         208.9       1.0X


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

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
from_utc_timestamp:                       Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
from_utc_timestamp wholestage off                   616            619           4         16.2          61.6       1.0X
from_utc_timestamp wholestage on                    662            664           3         15.1          66.2       0.9X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
to_utc_timestamp:                         Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
to_utc_timestamp wholestage off                     667            670           5         15.0          66.7       1.0X
to_utc_timestamp wholestage on                      681            687           5         14.7          68.1       1.0X


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

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
cast interval:                            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
cast interval wholestage off                        181            182           0         55.1          18.1       1.0X
cast interval wholestage on                         179            184           3         55.8          17.9       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
datediff:                                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
datediff wholestage off                             827            846          27         12.1          82.7       1.0X
datediff wholestage on                              825            833          14         12.1          82.5       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
months_between:                           Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
months_between wholestage off                      2538           2540           2          3.9         253.8       1.0X
months_between wholestage on                       2590           2607          17          3.9         259.0       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
window:                                   Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
window wholestage off                               457            477          28          2.2         457.5       1.0X
window wholestage on                                494            502          10          2.0         494.3       0.9X


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

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
date_trunc YEAR:                          Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc YEAR wholestage off                      628            630           3         15.9          62.8       1.0X
date_trunc YEAR wholestage on                       632            643          14         15.8          63.2       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
date_trunc YYYY:                          Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc YYYY wholestage off                      626            632           9         16.0          62.6       1.0X
date_trunc YYYY wholestage on                       632            635           3         15.8          63.2       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
date_trunc YY:                            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc YY wholestage off                        628            629           2         15.9          62.8       1.0X
date_trunc YY wholestage on                         631            632           1         15.8          63.1       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
date_trunc MON:                           Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc MON wholestage off                       634            635           2         15.8          63.4       1.0X
date_trunc MON wholestage on                        616            619           3         16.2          61.6       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
date_trunc MONTH:                         Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc MONTH wholestage off                     635            636           1         15.8          63.5       1.0X
date_trunc MONTH wholestage on                      616            640          34         16.2          61.6       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
date_trunc MM:                            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc MM wholestage off                        638            639           2         15.7          63.8       1.0X
date_trunc MM wholestage on                         615            621           6         16.3          61.5       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
date_trunc DAY:                           Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc DAY wholestage off                       503            503           0         19.9          50.3       1.0X
date_trunc DAY wholestage on                        487            492           7         20.5          48.7       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
date_trunc DD:                            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc DD wholestage off                        500            502           3         20.0          50.0       1.0X
date_trunc DD wholestage on                         485            487           2         20.6          48.5       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
date_trunc HOUR:                          Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc HOUR wholestage off                      527            528           1         19.0          52.7       1.0X
date_trunc HOUR wholestage on                       501            503           2         19.9          50.1       1.1X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
date_trunc MINUTE:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc MINUTE wholestage off                    505            518          19         19.8          50.5       1.0X
date_trunc MINUTE wholestage on                     481            483           3         20.8          48.1       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
date_trunc SECOND:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc SECOND wholestage off                    258            259           1         38.8          25.8       1.0X
date_trunc SECOND wholestage on                     221            223           2         45.2          22.1       1.2X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
date_trunc WEEK:                          Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc WEEK wholestage off                      534            536           3         18.7          53.4       1.0X
date_trunc WEEK wholestage on                       512            514           2         19.5          51.2       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
date_trunc QUARTER:                       Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
date_trunc QUARTER wholestage off                   714            716           3         14.0          71.4       1.0X
date_trunc QUARTER wholestage on                    693            696           3         14.4          69.3       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
trunc year:                               Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
trunc year wholestage off                           666            673           9         15.0          66.6       1.0X
trunc year wholestage on                            632            633           1         15.8          63.2       1.1X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
trunc yyyy:                               Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
trunc yyyy wholestage off                           669            669           1         15.0          66.9       1.0X
trunc yyyy wholestage on                            633            637           4         15.8          63.3       1.1X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
trunc yy:                                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
trunc yy wholestage off                             673            679           7         14.9          67.3       1.0X
trunc yy wholestage on                              636            642          12         15.7          63.6       1.1X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
trunc mon:                                Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
trunc mon wholestage off                            633            633           1         15.8          63.3       1.0X
trunc mon wholestage on                             599            603           3         16.7          59.9       1.1X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
trunc month:                              Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
trunc month wholestage off                          626            627           1         16.0          62.6       1.0X
trunc month wholestage on                           601            610          18         16.7          60.1       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
trunc mm:                                 Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
trunc mm wholestage off                             627            632           7         15.9          62.7       1.0X
trunc mm wholestage on                              599            602           3         16.7          59.9       1.0X


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

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
to timestamp str:                         Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
to timestamp str wholestage off                      77             80           4         12.9          77.3       1.0X
to timestamp str wholestage on                       79             81           3         12.7          78.9       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
to_timestamp:                             Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
to_timestamp wholestage off                         457            458           0          2.2         457.4       1.0X
to_timestamp wholestage on                          455            456           1          2.2         454.9       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
to_unix_timestamp:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
to_unix_timestamp wholestage off                    459            460           1          2.2         459.4       1.0X
to_unix_timestamp wholestage on                     445            446           1          2.2         444.9       1.0X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
to date str:                              Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
to date str wholestage off                          108            108           0          9.3         107.5       1.0X
to date str wholestage on                           102            104           2          9.8         102.0       1.1X

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
to_date:                                  Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
to_date wholestage off                              472            473           1          2.1         472.0       1.0X
to_date wholestage on                               455            465          20          2.2         454.9       1.0X


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

OpenJDK 64-Bit Server VM 21.0.11+10-LTS on Linux 6.17.0-1018-azure
AMD EPYC 9V74 80-Core Processor
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                                  246            249           4         20.3          49.2       1.0X
From java.time.LocalDate                            170            172           2         29.4          34.0       1.4X
Collect java.sql.Date                              1034           1087          61          4.8         206.9       0.2X
Collect java.time.LocalDate                         701            803         158          7.1         140.1       0.4X
From java.sql.Timestamp                             173            203          32         29.0          34.5       1.4X
From java.time.Instant                              133            135           3         37.5          26.6       1.8X
Collect longs                                       749            785          61          6.7         149.9       0.3X
Collect java.sql.Timestamp                          869            925          84          5.8         173.7       0.3X
Collect java.time.Instant                           734            860         125          6.8         146.8       0.3X
java.sql.Date to Hive string                       3281           3391         127          1.5         656.2       0.1X
java.time.LocalDate to Hive string                 2410           2458          52          2.1         481.9       0.1X
java.sql.Timestamp to Hive string                  5030           5142         156          1.0        1006.1       0.0X
java.time.Instant to Hive string                   3179           3225          48          1.6         635.8       0.1X


