Hi
I am trying to design a database (backend of a website) and just need a few pointers on the best way to handle dates, specifically storing them and then the display within webpages and reports.
I don't want people using this in USA confusing dates with people in UK.
I know this should be straight-forward but I would be grateful if anyone can give me a link to or explain the best practices for doing this.
Database: Microsoft SQL Server 2005.
Reports: Microsoft SQL Server Reporting Services
Webpages: .NET
TIA.
I am trying to design a database (backend of a website) and just need a few pointers on the best way to handle dates, specifically storing them and then the display within webpages and reports.
I don't want people using this in USA confusing dates with people in UK.
I know this should be straight-forward but I would be grateful if anyone can give me a link to or explain the best practices for doing this.
Database: Microsoft SQL Server 2005.
Reports: Microsoft SQL Server Reporting Services
Webpages: .NET
TIA.
Comment