With a YYYY-MM-DD HH:MM:SS date I always store the UTC time. When I pull to display I translate timezones with built-in PHP functions and classes. I believe that is one correct way to do it and it makes sense to me. May I handle YYYY-MM-DD the same way?
How to handle timezone for dates?
php;time;date format
That would depend on how you interpreted the date.If you use the date as though it were YYYY-MM-DD 00:00:00 (or any specific time) then you would probably want to take account of time zones.If you use the date as just on indication of the day then you probably don't.This is vague as without the context of what you are doing with the dates, it is just guesswork.