IIS Data base Issuses

By ddobson ·
We have a SQL database and a webserver that talks to the database. When viewed on the webpage some of these dates are displayed in US short date format and others are in UK short date format. They all need to be in UK short date format. It wouldnt be much of a problem but the system keeps expiring these clients based on the US short date format.

Any help please?!?!?!?!?!?!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Are they showing the date in the database?

by Tony Hopkinson In reply to IIS Data base Issuses

If they are being formatted for dsiplay, then that's either being done in the display control, or possibly in the select statement that gets them.
Generally this sort of thing happens on entering the data though.
Usually by taking the formatted value from teh date control and then leaving it the database to guess what format the date is in.

For there to be a mixture of outputs on display (a much simpler problem, the formatting must be hardcoded) you need to look at days > 12.

Any other date is ambiguous which is why you should never use the formatted date value for the insert / update to the database.

Related Discussions

Related Forums