That is not a formatting issue but time zone. The clue is that the "error" is exactly 1 hour from midnight. You haven't given sufficient information/detail for a solution to be offered but here's what you need to do...
- Know where the date should be coming from.
- Find out where it is coming from.
(Should a SQL script or trigger be inserting using the database datetime, so all entries in the table are date-stamped using the same clock? Or do you want to send a local client-side (or other-server-side) value across the wire to the central database?) Your problem here is clearly that you have done a bit of both from time zones 1 hour apart.
- Then (a) once you have a clear notion of how it should work, if (b) resolving time zone differences is necessary and (c) you are still uncertain... then post another question providing the details, related program code and database scripts/procs.
Good luck