PostgreSQL supports numerous built-in functions that assist us in manipulating the date and time values efficiently. In Postgres, the built-in functions likeNOW(),CURRENT_DATE,CURRENT_TIMESTAMP, andLOCALTIMESTAMPare used with theSELECTstatement to get today’s date. These functions can be used wi...
This command works on every OS/version we test on (including CentOS 6) but does not work on CentOS 7. SELinux does not appear to be a factor - I think it must be some version mismatch or some kind of enforcement. I can't look at this any more today but I'll pick it up next ...