search envelope-o feed check
Home Unanswered Active Tags New Question
user comment-o

Storing Date Times in SQL Server throws erros

Asked by Ron Sell
9 years ago.
Conversion from string "Mon Jan 10 2011 21:30:00 GMT-060" to type 'Date' is not valid. I get all types of different dates from the calendar from different browsers. I would really like DayPilot Calendar to give me the date in a format that MS SQL Server won't balk at. How do I get rid of time zones? How do I get it in a format SQL server likes from al browsers? Thanks a ton, this is throwing errors for some of my users.
Comment posted by Ron Sell
9 years ago.

actually what the dayPilotCalendar returned to my vb.net code was "Mon Jan 10 2011 21:30:00 GMT-0600 (Central Standard Time)"

Anyone know how to deal with this? I think it was a Chrome browser.

Ron

This question is more than 3 months old and has been closed. Please create a new question if you have anything to add.