jQuery Grid Plugin - jqGrid - Topic: Updating Date Values in SQL Server http://www.trirand.com/blog/?page_id=393/help/updating-date-values-in-sql-server Simple:Press Version 5.7.5.3 ldhansen on Updating Date Values in SQL Server http://www.trirand.com/blog/?page_id=393/help/updating-date-values-in-sql-server#p29422 Help http://www.trirand.com/blog/?page_id=393/help/updating-date-values-in-sql-server#p29422 RESOLVED

my problem was I needed to add this line;

$grid->setUserTime('Y-m-d');

]]> Thu, 29 Aug 2013 20:46:00 +0300 ldhansen on Updating Date Values in SQL Server http://www.trirand.com/blog/?page_id=393/help/updating-date-values-in-sql-server#p29416 Help http://www.trirand.com/blog/?page_id=393/help/updating-date-values-in-sql-server#p29416 I'm using jqGrid 4.5.2.  I've successfully created northwind database in SQL Server 2008R2.  I have successfully connected jqgrid to the database and I can update data in all fields from jqGrid except for Date field.  I have set the "ReturnDatesAsStrings" on the Connection array.

No matter what date I enter, the date in the database changes to 1970-01-01.

What other changes to the \examples\editing_data\datepicker\grid.php do I need to make in order for date values to work correctly with SQL Server?

]]> Wed, 28 Aug 2013 23:24:18 +0300