How to parse date format 'MMM d yyyy' generated in SQL Server in Kendo?

Question

We are using SQL Server generating some data One of the column is Date, which is defined as 'MMM d yyyy'. So, the possible values are:

Jan  1 2017
Jan 21 2017
Jan 12 2017
...

note that, there are 2 spaces in the 1st sample between 'Jan' and '1'. How can we parse this date in Kendo Grid?

kendo.parseDate seems does not support this format.

Our plan is to change the output of SQL Server, but want to see whether there are some simple way on kendo side to do this.

Thanks

The best possible fix would be to stop storing dates as strings. That is why we have the date and datetime datatypes. — Sean Lange
it is not stored in SQL, it is output as VARCHAR(11) for format purpose. — urlreader
So in your SQL database, you have a record with value such as 2017-01-01, correct? You are trying to display this value in kendo grid as Jan 1 2017, correct? — ShawnOrr

John Cappelletti John Cappelletti · Accepted Answer · 2017-09-06T16:07:42

Been a while, but perhaps this may help

Example

kendo.parseDate(new Date("Jan  1 2017"), "MM/dd/yyyy");

In my head,

It makes more sense to store dates as dates in SQL Server. Too many things can go wrong by trusting strings.
It would be a small matter to convert your string in SQL Server with either convert() or if 2012+ try_convert().

Example

Declare @YourTable Table ([DateStr] varchar(50))
Insert Into @YourTable Values 
 ('Jan  1 2017')
,('Jan 21 2017')
,('Jan 12 2017')

Select *
      ,AsDate = try_convert(date,DateStr) 
 From @YourTable

Returns

DateStr       AsDate
Jan  1 2017   2017-01-01
Jan 21 2017   2017-01-21
Jan 12 2017   2017-01-12

How to parse date format 'MMM d yyyy' generated in SQL Server in Kendo?

1 Answers