How Date/Date Time is Stored in SFDC Backend??
In Salesforce all Date or Date/Time data is stored in UTC — Coordinated Universal Time. UTC is not a time zone but rather a time standard used commonly around the world.
When a record is saved, field values are adjusted from the user’s time zone to UTC, and then adjusted back to the viewer’s time zone when displayed in record detail pages and reports.