pg_query_params providing date parameters with postgresql

Question

pg_query_params( SELECT * FROM example WHERE date >= (NOW() - INTERVAL '1 day'), array() );

Above syntax will work, but how can I provide dates dynamically with pg_query_params?

I have tried

pg_query_params( SELECT * FROM example WHERE date >= (NOW() - INTERVAL $1), array('1 day') );
pg_query_params( SELECT * FROM example WHERE date >= (NOW() - INTERVAL $1 day), array('1') );

and several other combinations but they do not seem to work. What is the correct way to do this?

Vao Tsun · Accepted Answer · 2016-10-26 07:17:55Z

1

try this way:

pg_query_params('SELECT * FROM example WHERE date >= (NOW() - $1::interval)', array('1 day') );

answered Oct 26, 2016 at 7:17

Vao Tsun

52.5k13 gold badges114 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Aaron Over a year ago

Worked. How did you figure this out?

Vao Tsun Over a year ago

pure luck - I used to use cast instead defining type before value, like now() - '2016-01-01'::timestamptz instead of now() - timestamptz '2016-01-01' and so on. So I just rewrote your QRY to be cosy with and it worked from first try.

Collectives™ on Stack Overflow

pg_query_params providing date parameters with postgresql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related