How to add a variable to a timestamp.

[Eagna <eagna@xxxxxxxxxxxxxx>]

Hi,

I'm trying to do something like this.

SELECT

  d.i,

  h.i,

 '2022-10-31 00:00:00'::TIMESTAMP  + INTERVAL 'd.i DAY'

FROM

  GENERATE_SERIES(0,  6) AS d(i),

  GENERATE_SERIES(0, 23) AS h(i);

where I add d.i days (and also h.i hours) to a timestamp.

I can't seem to get this to work. Any ideas appreciated.

E.

Sent with Proton Mail secure email.