Extracting date from database to windows service program gives improper format.

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

I have windows service program in which I am accessing database and I have simple query to extract expiry_date and some fields too , But when i run this query in winForms application it gives resulting date into proper format (e.g 01/02/2014) but when same query runs in windows service program it gives improper format (e.g 1/2/2014).
Can anyone tell me what is the reason?

Thanks

Posted 26-Aug-15 22:10pm

Member 11543226

Add a Solution

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 · 2015-08-26T22:17:00

Probably, because you don;t specify a format in the service, so it is using the system default. Dates (and DateTime values) don't have any intrinsic format, they are stored as a number of ticks since since an arbitrary point in time. They only acquire any formatting when they are converted to strings for presentation.

So look at your conversion / presentation code and see what happens there.

Maciej Los · Answer 2 · 2015-08-26T22:23:00

Solution 2

Date is a date[^] and nothing else! It does not have specific format! You can format it using String.Format() or ToString() function.

Please, see:
Standard Date and Time Format Strings[^]
Custom Date and Time Format Strings[^]

Posted 26-Aug-15 22:23pm

Maciej Los

Comments

Member 11543226 27-Aug-15 4:38am

I also changed my system date format to mm/dd/yyyy but still it gives same error

Maciej Los 27-Aug-15 4:58am

Seems, you don't get it... Your system date format is not important! The way you display date is very important!

Member 11543226 27-Aug-15 5:13am

I displayed date in exact format as saved in database I cannot convert it in any custom string format