Refactor the SQL function: date_to_unix_ts() by using calendar:datetime_to_gregorian_seconds/1. This change also added validation for the input date format.
date_to_unix_ts()
calendar:datetime_to_gregorian_seconds/1