NOW() and GET_DATETIME_COMPONENT compatibility

1

There are two variables.

The first is the current datetime that is set with the formula NOW().
The second is the date extracted from NOW() using the formula GET_DATETIME_COMPONENT(NOW(), “date”).

The results are inconsistent.

The first date variable produces a value of 09/19/2021

The second variable produces a value of 20.

Is this a bug or am I doing it wrong?

2

Hi Jim,

the formula is OK and working right. Today is the 20th of September.

The only thing I can think of is that you are in a different timezone, than NOW() is anticipating.
You can check this with LOCAL_TIMEZONE().