----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: BalajiKrishnan Message 1 in Discussion I want to change the default date formate in sql server and IIS. If I change in Regional setting, it is not reflecting in this. In regional setting it shows dd/mm/yyyy. in command prompt if is say date it show in this fomate(27/04/2004). It is correct. In sql server if i save select getdate() - it shows (2004-04-27 08:59:01.667) - yyyy-mm-dd In IIS - i written one asp page to get the time - it shows 4/27/2004. What I feel was, SQL server and IIS is not taking date format from regional setting. I want to change the date format to dd/mm/yyyy or dd/mmm/yyyy in sql server and IIS. How can i do this ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
