bug: date_add with now should return right value

[TCeason]

Search before asking

• I had searched in the issues and found no similar issues.

Version

main

What's Wrong?

If now() at 2024-10-28 19:43:00 Asia/Shanghai, date_add(year, 1, now()) will return unexpect value.

How to Reproduce?

set timezone='Asia/Shanghai';

:) select date_add('year', 1, now()); --BUG

SELECT DATE_ADD(YEAR, INTERVAL 1, now())

┌────────────────────────────┐
│  DATE_ADD(YEAR, 1, now())  │
│          Timestamp         │
├────────────────────────────┤
│ 2025-10-29 03:50:02.806422 │
└────────────────────────────┘
1 row read in 0.025 sec. Processed 1 row, 1B (39.59 rows/s, 39B/s)


:) select date_add('year', 1, '2024-10-28 19:49:52.684937')::TIMESTAMP; -- normal

SELECT DATE_ADD(YEAR, INTERVAL 1, '2024-10-28 19:49:52.684937')::TIMESTAMP

┌────────────────────────────────────────────────────────────┐
│ DATE_ADD(YEAR, 1, '2024-10-28 19:49:52.684937')::TIMESTAMP │
│                          Timestamp                         │
├────────────────────────────────────────────────────────────┤
│ 2025-10-28 00:00:00                                        │
└────────────────────────────────────────────────────────────┘
1 row read in 0.061 sec. Processed 1 row, 1B (16.37 rows/s, 16B/s)

tmp resolve

:) select now(), to_timestamp(add_years(today(),1))+(current_timestamp() - today());

SELECT
    now(),
    (to_timestamp(add_years(today(), 1)) + (current_timestamp() - today()))

┌────────────────────────────────────────────────────────────────────────────────────────────────────┐
│            now()           │ to_timestamp(add_years(today(), 1)) + (current_timestamp() - today()) │
│          Timestamp         │                               Timestamp                               │
├────────────────────────────┼───────────────────────────────────────────────────────────────────────┤
│ 2024-10-28 19:59:39.722331 │ 2025-10-28 19:59:39.722331                                            │
└────────────────────────────────────────────────────────────────────────────────────────────────────┘

Are you willing to submit PR?

• Yes I am willing to submit a PR!

[TCeason]

Prettry format is err:

:) select date_add('year', 1, now()); --BUG

SELECT DATE_ADD(YEAR, INTERVAL 1, now())

SELECT DATE_ADD(YEAR, INTERVAL 1, now())
error: APIError: ResponseError with 1005: error: 
  --> SQL:1:32
  |
1 | SELECT DATE_ADD(YEAR, INTERVAL 1, now())
  | ------ ---------               ^ unexpected `1`, expecting `)` or `,`
  | |      |       |                
  | |      |       while parsing `(<expr> [, ...])`
  | |      while parsing expression
  | while parsing `SELECT ...`