Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Date Setting

Author  Topic 

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2004-08-30 : 18:56:38
I am creating a application that i will be running in US and Australia. How to handle date data in the application to be able run at both places.
Australian Date: dd/mm/yyyy
US:-mm/dd/yyyy

Thanks




mk_garg

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-30 : 18:59:00
You should handle the conversion at the front-end. The front-end would find out the country setting either by checking a user table or checking the user's computer, then it would change the display of the date.

Tara
Go to Top of Page

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2004-08-31 : 02:00:54
This thread might help too http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=38983

OS
Go to Top of Page

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2004-08-31 : 02:03:56
Thanks for that!

mk_garg
Go to Top of Page
   

- Advertisement -