Couldn't you use a scheduled job in the database to push NOW() through InSQL to each PLC?
Just a short SQL script for each PLC to take current time, format it properly, and push it to the PLC's. For Microsoft SQL Server, you can use the SQLServerAgent to schedule the jobs in the Database itself. Just use a daily schedule to push the times out.