Date time format problem

Question

0.00/5 (No votes)

See more:

hi guys..

I am trying to insert the System date in oracle and i am facing the problem with the format.The format is mm/dd/yyyy but oracle takes the date in format dd-mmm-yy format.

Can anybody help me to convert this date into the required format?

Posted 25-Apr-11 17:10pm

ashu2188

Add a Solution

Comments

Sergey Alexandrovich Kryukov 25-Apr-11 23:34pm

If you say it's solved, are you going to formally accept the answers (green button)?
Thank you.
--SA

2 solutions

Solution 1

You can use the ToString method of DateTime class. Pass the necessary format, in your case dateTime.Now.ToString(“dd/mm/yyyy”);

Take a look at this article[^] for further reading.

Posted 25-Apr-11 17:18pm

Tarakeshwar Reddy

Updated 25-Apr-11 17:31pm

v3

Comments

Sergey Alexandrovich Kryukov 25-Apr-11 23:30pm

Correct (actually, not exactly right format; better fix it, use "/" and "mm"). Will you fix it?
See my answer for more detail.
--SA

Tarakeshwar Reddy 25-Apr-11 23:31pm

Thanks SA upated it. 5 for your answer and your update

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)

Sergey Alexandrovich Kryukov · Accepted Answer · 2011-04-25T17:22:00

This is quite easy.

This is related to Date and Time formatting:
http://msdn.microsoft.com/en-us/library/az4se3k1.aspx[^],
http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx[^].

Here is how you can use custom time formatting to obtain the date to your spec:

System.DateTime time = System.DataTime.Now; //just for example

//...

string timeOracle = time.ToString("dd/mm/yyyy");

You can also format string to a specified culture:

string timeOracle =
   time.ToString(new CultureInfo("en-gb")); //it looks like what Oracle uses, according the the question

—SA