Programming, error messages and sample code
How to set culture in web.config to change datetime format?
Programming, error messages and sample code > ASP.NET
Error1: String was not recognized as a valid DateTime
Error2: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
How to fix it?
- Set culture in web.config
In an ASP.NET Web page, you can set to two culture values, the Culture and UICulture properties. The Culture value determines the results of culture-dependent functions, such as the date, number, and currency formatting, and so on. The UICulture value determines which resources are loaded for the page.
Solution
add a globalization section to the Web.config file, and then set the uiculture and culture attributes, as shown in the following example:
Error2: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
How to fix it?
- Set culture in web.config
In an ASP.NET Web page, you can set to two culture values, the Culture and UICulture properties. The Culture value determines the results of culture-dependent functions, such as the date, number, and currency formatting, and so on. The UICulture value determines which resources are loaded for the page.
Solution
add a globalization section to the Web.config file, and then set the uiculture and culture attributes, as shown in the following example:
<globalization uiCulture="es" culture="es-MX" />
And for more detail about coding, you can refer to:
https://docs.microsoft.com/en-us/troubleshoot/aspnet/set-current-culture