Insert statement

[nimishauk]

Hi
Below is my insert statement
INSERT INTO AppUser(Forename, Surname, Job_Title, DOB, Employee_Number, User_Type,Employee_Site_ID)
values ('J', 'N', 'GMANAGER', '1955-07-20', '01', 'E', '2 ');

When the row gets inserted into the table the DOB is saved as '1955/07/20' rather '1955-07-20' , how I had intended it to be. I have tried a few styles of convert function, it has not helped. The DOB is stored as a datetime (8) in the table design.
Any suggestions
ta
Nimisha

 

[JamesLean]

You are confusing how the date is being displayed in your app with how it is actually being stored in SQL Server. Read this FAQ for information:

Why Does SQL Server Display My Data Like That?
faq183-3007 --James