Date picker time is an hour off?

[belzoni]

Hello,

I'm using a datepicker on a form and when I enter a time, say 8 AM, it's submitted into the SQL database as 7AM. It's always 1 hour off.

If i change the time to 9AM it will be entered as 8AM etc. The datepicker is set to local time.

Has anyone run into this issue?

thanks

[TomVine]

Assume this is because of differences in timezones - have you tried date time zone as UTC?

What code are you use to patch the SQL table?

[belzoni]

Thank you for your response.

I'm not using a patch for the submit. I using a form submit to insert directly into the table. The SQL field is a datetimeoffset because i've read that the normal datetime field is not great for filtering against.