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
13 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.
asp.net
Comment posted by Ron Sell
13 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 1 months old and has been closed. Please create a new question if you have anything to add.
Tools
E-mail notifications
Feed
Related Questions
Event rendering different on Chrome
changing the culture & UICulture of the scheduler control?
Calender controls
entity framework
Move Event Handler
Using SQL with DayPilot
Allocating a color to each event
datapilot.mdb issue
Export to PNG
Change Date Format
startDate
How to export excel with table
calendar to bind to custom sql on refresh
need a sample program

Products

Learn

Get Support

DayPilot Pro

Event calendar/scheduling AJAX components. Available for JavaScript/HTML5/jQuery, ASP.NET, ASP.NET MVC. Build resource booking, project management, time tracking applications, personal and shared event calendars.