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
 SQL Server Development (2000)
 not able to change date .

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-08-15 : 07:34:04
kuchimanchi girija writes "Hi,

I am developing asp.net application. There i have set culture to indian format.. where i get dd/mm/yyyy date format .
I am using MSsql as backend. i am getting problem while storing in database as invalid date format. Even i changed date format in sql server to 'dd/mm/yyyy' format using set dateformat...
please give me solution for this..
Thanks and regards"

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2005-08-15 : 07:48:12
Hi there,

How are you storing the date? Can you post the bit of code you're using. The date format you refer to is generally the same one we use here in Australia, and we don't have any problems with it...

Tim
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-16 : 02:00:35
Use the universal date format yyyy-mm-dd or yyyymmdd to store date to SQL server table from your asp.net application

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -