Comparing Dates in Conditions, and Accounting for Timezones

So I did some more digging and found this thread:

And I am starting to get why this is tricky. I think I may be able to phrase my question in a more helpful way now.

If for a workflow, I want to compare Current Date to a date stored in the database to see if they are the same day, are those both UTC because I am working with the database, or are they localized because they involve a user interaction? Or neither?