Last post Jun 19, 2007 05:41 AM by dt008
Jun 18, 2007 08:13 PM|Christianpmg|LINK
In my web application I have a calendar control and textbox control that receives currency numbers, all of these works fine, with their correct formats. But when I insert the information of the textbox
and calendar control in my SQL Server Database doesn't work, the reason is because most of my applications in my computer are in Spanish version including SQL Server and Windows XP, the final query that I send to my database is:
Insert Into Prueba Values (13.89,'07/31/1994')
This query in an SQL Server Spanish version is incorrect because it should be: Insert Into Prueba Values (13.89,'31/07/1994')
I want to know how can I do to convert an English format date to Hispanic format date, I want something dynamic because in the future I have to develop the same web application in French (I am going to use Resource files in this web application), I want
to create a function or a class that identifies the localization of the web application for this case "en-US" and identifies the localization of the server for this case "es-EC", and it converts the format date of the server for this case "es-EC", I want this
function or class converts the format date of the localizated web application to the format date of the server, if somebody knows a basic function or idea to change between format dates I would thankful.
Thank you again and best regards.
Jun 19, 2007 05:41 AM|dt008|LINK
You can use t-sql's convert function to convert between locales, but by far the most correct solution is to pass your date arguments through sql parameters, either you use handwritten sql statements or stored procedures.