471,353 Members | 1,683 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,353 software developers and data experts.

Using american dates by default

Hi guys,

I'm developing a web app on a UK computer. When I put a date into a textbox,
its in the format DD/MM/YY. The DateTime object takes that in and handles
in perfectly.

Now, I need to start using the american format MM/DD/YY.

My question is, how do I get the DateTime object to recognise what I'm passing
in as an American date? If the machine is installed on an american server,
will it immediately expect the dates as american? Or do I need to do something
else?

Many thanks

Simon
Feb 10 '06 #1
6 1439
thechaosengine wrote:
I'm developing a web app on a UK computer. When I put a date into a textbox,
its in the format DD/MM/YY. The DateTime object takes that in and handles
in perfectly.

Now, I need to start using the american format MM/DD/YY.

My question is, how do I get the DateTime object to recognise what I'm passing
in as an American date? If the machine is installed on an american server,
will it immediately expect the dates as american? Or do I need to do something
else?


You can tell DateTime.Parse which CultureInfo to use. If you don't
specify anything, it uses the CultureInfo for the current thread.

Jon

Feb 10 '06 #2
> You can tell DateTime.Parse which CultureInfo to use. If you don't
specify anything, it uses the CultureInfo for the current thread.

Jon


Sorry to hijack slightly, however how do you instruct SQL server to save
dates in UK format?

The DateTime class again maintains my uk date however SQL writes it out in
america format, any clues ideas?

Thanks,
Taz
Feb 10 '06 #3
Hello Jon Skeet [C# MVP],

OK, thats cool.

Now, just one last thing. Would I be right in thinking that if the code is
running on an american server, it will default to the american way of doing
dates?

I'm pretty sure it should...

Thanks

Simon
Feb 10 '06 #4
re:
The DateTime class again maintains my uk date however SQL writes it out in america format, any
clues ideas?
If you want dates to be displayed using uk format, set "culture" and "uiCulture",
in the globalization section of web.config, to "en-GB".

Anything you display in ASP.NET pages from that point on,
will be displayed using UK date and currency formats.

<globalization culture="en-GB" uiCulture="en-GB" />

Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================
"Tarun Mistry" <uk***********@gmail.com> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...
You can tell DateTime.Parse which CultureInfo to use. If you don't
specify anything, it uses the CultureInfo for the current thread.

Jon

Sorry to hijack slightly, however how do you instruct SQL server to save dates in UK format?

The DateTime class again maintains my uk date however SQL writes it out in america format, any
clues ideas?

Thanks,
Taz

Feb 10 '06 #5
thechaosengine wrote:
OK, thats cool.

Now, just one last thing. Would I be right in thinking that if the code is
running on an american server, it will default to the american way of doing
dates?

I'm pretty sure it should...


*Probably*. If it's an ASP.NET app, you may find it takes the UI
culture (set on the thread from what the browser provides) rather than
the "normal" culture. I can't remember off the top of my head.
Definitely try it on a US-based server with browser settings for US and
UK.

Jon

Feb 10 '06 #6
Hi Juan

Your code has been proved a gr8 help to me. Thnx a lot.

Ruju
"Juan T. Llibre" wrote:
re:
The DateTime class again maintains my uk date however SQL writes it out in america format, any
clues ideas?


If you want dates to be displayed using uk format, set "culture" and "uiCulture",
in the globalization section of web.config, to "en-GB".

Anything you display in ASP.NET pages from that point on,
will be displayed using UK date and currency formats.

<globalization culture="en-GB" uiCulture="en-GB" />

Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================
"Tarun Mistry" <uk***********@gmail.com> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...
You can tell DateTime.Parse which CultureInfo to use. If you don't
specify anything, it uses the CultureInfo for the current thread.

Jon

Sorry to hijack slightly, however how do you instruct SQL server to save dates in UK format?

The DateTime class again maintains my uk date however SQL writes it out in america format, any
clues ideas?

Thanks,
Taz


Mar 16 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Steve Elliott | last post: by
2 posts views Thread by Grant Merwitz | last post: by
7 posts views Thread by thechaosengine | last post: by
9 posts views Thread by Simon Harvey | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.