jQuery Grid Plugin - jqGridForum

Topic RSS

Related Topics sp_TopicIcon

Updating Date Values in SQL Server

Tags: SQLServer dates

28/08/2013
23:24

ldhansen

New Member

Members

Forum Posts: 2

Member Since:
28/08/2013

Offline

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?

29/08/2013
20:46

ldhansen

New Member

Members

Forum Posts: 2

Member Since:
28/08/2013

Offline

RESOLVED

my problem was I needed to add this line;

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

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
36 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66