Time format issue while retrieving from database

Question

0.00/5 (No votes)

See more:

I am having problem while retrieving date time from sq l database.
I have Column in with datatype as DATE TIME .
I am using java script date time picker in from end to save the date time with option to save the time in 24 hours format.
It getting save in 24 hours format but when i display that record in grid view
the time get converted in 12hours format

for example if i am saving 07/05/2012 17:35:00
if i am displaying the record in grid view or Text Box it show 07/05/2012 5:35:0 pm
i don't what this can any one help me with this any solution or code
i am trying but not getting success .

Thanks in advance

Posted 8-May-12 3:45am

Yadav Anil

Add a Solution

Comments

Sandeep Mewara 8-May-12 10:44am

Does that mean that in your Javascript datetime picker you have the desired date format?

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)

Ashish Sehajpal · Answer 1 · 2012-05-08T04:00:00

Try this :

ASP.NET

<asp:boundfield datafield="Your_Date_Column" dataformatstring="{0:dd/MM/yyyy HH:mm}" htmlencode="false" xmlns:asp="#unknown" />

You need to put that htmlencode attribute.
HTML-encoding field values helps to prevent cross-site scripting attacks and malicious content from being displayed. This property should be enabled whenever possible.