Hi,

I've had a website built for me using asp and mssql. Im getting errors relating to the date format in queries being submitted.

The asp is trying to insert dates in format dd/mm/yyyy, but after testing my mssql server is expecting the dates in format yyyy/mm/dd.

Is there a way of making this work (Without going through all the code and fomatting the dates to something my sql server can accept) i.e. is there someway of configuring my sql server to accept dates in the format?

Thanks for any help you can give me.

Matt

sql will accept dates in either yyyy/mm/dd or mm/dd/yyyy but not dd/mm/yyyy unless you use the set dateformat at the beginning of each query. Which seems like as much work as going through your code. I would recommend fixing your code to use one of the two normal date formats instead of the odd one you are using

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.