Personally, I would hardly use the CURRENT_DATE property. Instead, I would rather use CURRENT_TIMESTAMP as it records the time a button has been clicked, or user was logged in etc. Regarding the issue_date this can distinguish if an item was borrowed and returned on the same day. When extracting the timedate from the database, you can also format it by using in your query the date format option for postresql:
to_date(issue_date, 'DD Mon YYYY')
Personally, I would hardly use the CURRENT_DATE property. Instead, I would rather use CURRENT_TIMESTAMP as it records the time a button has been clicked, or user was logged in etc. Regarding the
issue_datethis can distinguish if an item was borrowed and returned on the same day. When extracting the timedate from the database, you can also format it by using in your query the date format option for postresql:to_date(issue_date, 'DD Mon YYYY')