SELECT to_char(now() + interval '-30 days', 'YYYYMMDDHH24MI') as time