date_part Postgresql

Alexis_Colon_Lugo · October 5, 2015, 6:03am

Hi
select date_part(‘days’, now() - fdate) as days from payinfo where socionum=‘12’ and days <300

i need to compare two dates and compare to days <300 but on postgresql no works

any idea
thanks

Peter_Fargo · October 5, 2015, 2:30pm

select date_part(‘days’, now() - fdate) as days from payinfo where socionum = ‘12’ and Cast(date_part(‘days’, now() - fdate) as integer) < 300

Alexis_Colon_Lugo · October 5, 2015, 3:09pm

Thanks Peter

Mauricio_Pulla · October 5, 2015, 3:25pm

Hi

Cast It is not necessary

select date_part(‘days’, now() - fdate) as days from payinfo where socionum=‘12’ and date_part(‘days’, now() - fdate) < 300

Mauricio

Peter_Fargo · October 5, 2015, 3:52pm

Thanks Mauricio. Old habits carried over