Excuse me, are in the gp database, if the date field is the date, I want to check the date the date to the date in the field of data between six months ago, how to write? If the date date for 20190531 to 6 months after the month the total number of days to 30 days how to solve? thank you

CodePudding user response:

 select now () - the interval 'six month'; 

This is the current time you wanted the corresponding points of six months ago?
Behind the "if in six months after the date date for 20190531 to the total number of days to 30 days how to solve" is what mean?

CodePudding user response:

reference 1st floor minsic78 response:

 select now () - the interval 'six month'; 

This is the current time you wanted the corresponding points of six months ago?
Behind the "if in six months after the date date for 20190531 to the total number of days to 30 days how to solve" is what mean?

Thank you,,,,,,, done