Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sduclosson
Starting Member
6 Posts |
 Posted - 2009-06-15 : 15:50:04
|
| HelloI have a program that represents date in dd/mm/yy format and we are having problems with a database that expects date in the format mm/dd/yy. I we use SET DATEFORMAT the problem is solved but we don´t know how to make the change permanent for that database or that session login.Thanks in advance. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-15 : 15:53:10
|
Can you pass the date as ISO (yyyymmdd) to the database?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
sduclosson
Starting Member
6 Posts |
Posted - 2009-06-15 : 16:30:06
|
| I can´t do that I´m not allowed to change the code in the program. I must find a server side solution but I can´t make the change for the whole server either only the database and session that I´m working on |
|
|
|
|
|
|
Problem with date format