Using Postgres, I want a timestamp in a specific format in a string in the query

Question

Here is the query I would like

SELECT * FROM information_schema.tables WHERE table_name = 'shop_ean_2016_06_12';

but "2016_06_12" in the query should be yesterday. I know "NOW() - '1 day'::INTERVAL" but I want to use it in the table name comparison.

Thank you for any way of doing this.

d1ll1nger · Accepted Answer · 2016-06-13 16:08:44Z

1

select * from information_schema.tables where table_name ='shop_ean_' || to_char(now() - interval '1 day','YYYY_MM_DD');

answered Jun 13, 2016 at 16:08

d1ll1nger

1,70113 silver badges16 bronze badges

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

1 Answer 1