How to parse Datetime SQL

Question

1.80/5 (2 votes)

See more:

How to parse SQL datetime in c#.

in Database its like this "2003-12-31 00:00:00"
i want like this "12/31/2003 12:00:00 AM"

please help...

Posted 28-May-15 19:59pm

Member 8222588

Add a Solution

Comments

Sergey Alexandrovich Kryukov 29-May-15 2:06am

You should not use strings where the time types are needed. Then you won't need to parse anything.
—SA

Member 8222588 29-May-15 2:09am

i use double quote to show date only here. in code its not a string

Saroj Kumar Sahu 29-May-15 2:14am

please mention the required Output format type also means is it in string or datetime ?

Member 8222588 29-May-15 2:17am

datetime

3 solutions

Solution 4

string date = "2003-12-31 00:00:00";
string [] Arr=Convert.ToDateTime(date).GetDateTimeFormats();
Console.WriteLine(Arr[71]);
Console.ReadLine();

Posted 15-Sep-15 22:04pm

RajeshKadam

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 · Accepted Answer · 2015-05-28T20:22:00

Dates in a database aren't stored with any format, unless they are stored as strings - which you say you aren't doing. Instead, they are stored as a number of microseconds since an arbitrary point in time.

They only acquire a format when you convert them to a string for presentation - which would normally be done in presentation software rather than in SQL so that it is in the format preferred by the user.
But you can select the format for the string in SQL:w3Schools[^]

Nakul Chaudhari · Accepted Answer · 2015-05-28T20:11:00

Solution 1

http://www.dotnetperls.com/datetime-sql[^]

Posted 28-May-15 20:11pm

Nakul Chaudhari