Kinoinsurse
New Member
We had all our sites hosted on a Win 2003 server (italian) and DBs on SQL Server 2005 (italian).Now we transfered everything to another host where they have Win 2008 (english us) and SQL Server 2008 (english us).All the dates are now mm/dd/yyyy instead of dd/mm/yyyy.Luckly I developed the asp code using some functions that passed ISO format for dates both in the stored procedure and dynamic queries (like 'yyyymmdd').And retrieving them we parsed the dates through other asp functions before display so everything went ok.Now we are switching to asp.net so since it seems to have great culture support I was wondering if it has some built in functions for this purprose, to read/pass/format/insert dates with SQL Server so that they are completely indipendent from the Win server locale and the SQL Server language, or do we have to code those functions ourselves as we did with classic asp?Also there may be issues with decimal and currency as well, treating the "," or "." for decimal separation. I'm not aware if passing decimal with "." to SQL Server (and using inside queries and stored procs) is always correct or there may be some issues like for dates.Any hint on those subject?