Click here to Skip to main content
15,891,136 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
CREATE TABLE Bk_employees
(
E_Id int PRIMARY KEY,
Manager_ID Int,
Department_ID Number,
First_Name varchar(255),
Last_Name varchar(255),
Email varchar(255),
Phone_Number Number,
Hire_Date Date,
Job_id Int,
Salary Number,
FOREIGN KEY (Job_ID) REFERENCES BK_Jobs(Job_ID)
);

INSERT INTO Bk_Employees (E_Id,Manager_ID,Department_ID,First_Name,Last_Name,Email,Phone_Number,Hire_Date,Job_id)
VALUES('4001','4003','2001','Bryson','K','bryson.kambole@imbasa.co.za','0782743385','06.06.2015','3001')
Posted
Comments
_Asif_ 30-Dec-15 7:25am    
Isn't the error is clear? SQL Serevr is not able to understand what is '06.06.2015'. change it to '06-Jun-2015' and test again.
ZurdoDev 30-Dec-15 8:26am    
This is the correct answer. Please post as solution.

1 solution

The problem is the date format you have used which SQL server unable to understand. please change '06.06.2015' to '06-Jun-2015' and test again.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900