now() function store DD/MM/YYYY

Question

4.50/5 (2 votes)

See more:

When inserting query using now() function it is throwing DD/MM/YYYY but need to send MM/DD/YYYY to database.

It is happen in windows server 2012.

What i am thinking time zone problem but where i need to change i am not getting give some solution.

Posted 4-Dec-13 2:56am

nane aa

Updated 4-Dec-13 2:59am

v2

Add a Solution

Comments

Mike Meinz 4-Dec-13 9:52am

You don't show any code so we have no way of knowing exactly what you mean by "inserting query using now() function".

1. Dates and Times should be stored in database columns that are of DateTime Data Type.
2. Values should be passed to the SQL Server using the SQLParameter class. This prevents SQL Injection Attacks, improves performance and properly handles Date and Time data types.

2 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)

OriginalGriff · Answer 1 · 2013-12-04T03:32:00

Solution 2

Don't format dates before sending them to a database: send them via a parameterised query as a DateTime object (as DateTime.Now returns) and store it in the DB as a DateTime column.
That way, you can do comparisons on it and everything will just work. You should only format dates when you actually need to present them to the user, and you should be using his prefered display format then anyway.

Posted 4-Dec-13 3:32am

OriginalGriff

Comments

Maciej Los 4-Dec-13 10:52am

Nothing to add ;)
+5!

nane aa 5-Dec-13 1:04am

I am configured same application in another system it coming properly MM/DD/YYYY.
But in my server only getting like DD/MM/YYYY.

OriginalGriff 5-Dec-13 3:41am

That's because you are using strings, instead of DateTime values. Don't.
Show the actual code that generate the error you see (i.e. how you actually know that there is a problem, not the code you think is creating the problem)

raneshtiwari · Answer 2 · 2013-12-04T03:30:00

Solution 1

Use below lines of code to format the date.
DateTime time = DateTime.Now;
time.ToString("MM/dd/yyyy", CultureInfo.InvariantCulture);

also check below link for more information

http://stackoverflow.com/questions/18595758/date-format-conversion-in-c-sharp[^]

Posted 4-Dec-13 3:30am

raneshtiwari

Comments

nane aa 5-Dec-13 1:04am

I am configured same application in another system it coming properly MM/DD/YYYY.
But in my server only getting like DD/MM/YYYY.