Remove T character in datetime value

Question

1.00/5 (1 vote)

See more:

Hi, I have a column in gridview in which I will display DateTime value being retrieved from database. I am using MVC and when the datetime value being passed through javascript, the space between date and time is getting replaced with an extra "T" character. I wish to remove this "T" and have the space back in between. Below are my codes in javascript:

$.ajax({
    async: false,
    type: "POST",
    url: "/Calendar/GetDateStart",
            }).success(function (data) {
                grid = $('#gdNotificationInformation').kendoUIGrid($.extend({
                    },
                    dataSource: {
                        data: data.data,
                    },
                    columns: [
                        { field: "a1", title: "Date Start", headerAttributes: { style: "overflow: visible; white-space: normal" } },
}],
}));
});

I am just showing the partial codes as this is the only codes segment that is having problem. Any help would be appreciated. Thank you.

What I have tried:

1. Convert the datetime value into string in Controller before pass it into javascript but no avail.

Posted 11-Oct-17 22:41pm

Jamie888

Updated 11-Oct-17 23:01pm

v3

Add a Solution

Comments

Karthik_Mahalingam 12-Oct-17 5:00am

check this
https://stackoverflow.com/a/27961034/1147428

Jamie888 12-Oct-17 5:03am

Sir, I have checked my controller. The value is indeed in datetime format without "T"

Karthik_Mahalingam 12-Oct-17 5:08am

can you post the datetime value which you are getting in controller

Jamie888 12-Oct-17 5:13am

It is in this format sir:
10/11/2017 7:42:16 AM DataType is DateTime

Karthik_Mahalingam 12-Oct-17 5:23am

then the problem is in UI

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2017-10-11T22:54:00

Solution 1

The chances are that it isn't: you need to check two things.
1) Look at the raw data in your DB: is it in a DATETIME or DATETIME2 column? If it isn't, that's your problem: its string based, and that a very bad idea. Change your database design so you store all data in appropriate data types. Anything else will give you more trouble than you can believe in the long term.
2) If it's a date format column, then the problem is the formatting applied to the gridview by the browser, or to the data by your code after it has been extracted from the database. Start by following the data through your system from the point of retrieval, and watch what happens to it: at some point it will be formated for the display and that's where the problem is happening.

Posted 11-Oct-17 22:54pm

OriginalGriff

Comments

Jamie888 12-Oct-17 4:57am

Sir, the data type I am using in database is DATETIME2. I have put a break point at the last line before it is entering javascript and the datetime value is still without "T". Only when it getting display it is showing the "T".

OriginalGriff 12-Oct-17 5:03am

Right: so the formatting is being applied by the browser, and you can't "just remove it" you need to look at the cell / column formatting to find out what is being applied. If there is no such formatting, then it's being rendered in the default datetime format for the client PC - which means it's either exactly what the user has asked for, or you need to override the default formatting. Do the last with care: remember that the internet is by it's nature international, and "fixing" a date format can have nasty repercussions for some users!

Jamie888 12-Oct-17 5:02am

I have updated the question to better reflect the scenario here.