How to covert dat time in csharp .net

Question

0.00/5 (No votes)

See more:

.NET3.5

Hi Frnds,

any one knows how to convert date time from (27/10/2011) to (2010/10/27)

i need to insert in to database table(sql format (yyyy/mm/dd).

please any one knows well in this scenario help me

Thaks
Venkat.S

Posted 26-Oct-11 22:07pm

vsiddi

Add a Solution

Comments

Al Moje 27-Oct-11 4:13am

Hi,
Google is your friend. There were so many kinds of date format….
Search key should be ‘how sql format (yyyy/mm/dd)’

3 solutions

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)

Mehdi Gholam · Answer 1 · 2011-10-26T22:21:00

Solution 1

A date can be converted to any format string with the ToString("format") overload for example date.ToString("yyyy-MM-dd").

Use '-' as a separator instead of '/' for dates as some database engines have problems with '/'.

Posted 26-Oct-11 22:21pm

Mehdi Gholam

Comments

Anil Honey 206 27-Oct-11 4:26am

Excuseme sir,
How to Insert in this format in c# 27 Oct 2011 1:59 AM

RaisKazi · Answer 2 · 2011-10-26T22:24:00

Solution 2

If you want to do this in C#.Net, use below syntax.

C#

string myDate = DateTime.Now.ToString("yyyy/MM/dd");

In case you want to do this in SQL, then have a look at below link.
http://www.w3schools.com/sql/func_convert.asp

Posted 26-Oct-11 22:24pm

RaisKazi

OriginalGriff · Answer 3 · 2011-10-26T22:27:00

The first this to do is: do not convert the date to any string format - instead, convert it to a DateTime value and store that directly in the database (in a SQL DateTime field). You can pass it in as a parameter, so it doesn't need to be converted.

It is easy to convert a string to a datetime:

C#

DateTime dt = DateTime.Parse(dateAsString);

This takes into account whatever date format settings the user has applied on his PC, so you don't have to concern yourself. It also has the advantage that any invalid dates are caught at this point, before they enter your database to cause problems later.

Storing it as a DateTime in the Database means that it is easier to use in comparisons, and also to format to the user PC settings when you retrieve the info later.