View Single Post
  #1 (permalink)  
Old March 21st, 2006, 07:45 PM
saif44 saif44 is offline
Authorized User
 
Join Date: Feb 2006
Location: , , .
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default date in sql server and in visual studio

i have come across some very strange beheaviour using date in sql server and VS.
i am using date as follow: DD/MM/YYYY, this get accepted by the sqlserver when you input this date from a VS form. however, when you pass some date to the sql (for example to compare to dates) it considers as MM/DD/YYYY. i don't know what's happening.

all my settings in the system is set to DD/MM/YYYY.

is there any way that you can set to make both sides understand one format

anyone can help please?