hi...
i have created the table with columns
NAME VARCHAR(30)
DOB SMALLDATETIME

i want to insert a record using the insert statement.
now i tried to insert the record using the following statement

insert into tbDetails values('Jhon', '13/06/1985')
it gave me an error stating
"The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value. The statement has been terminated."
so can u please help me solving this issue.

Hi, krsihnasamaga.

Although I am just learning all this now, like you, see below:

Use <NameOfDatabase>

Insert into <TableName>
(Name, DOB)
values('Jhon', '1985-06-13')

SELECT * from <TableName>

Cheers,
fskilnik

Hi krishnasamaga,

An alternative to inserting the date is to use the format dd-mmm-yyyy eg. 25-Sep-2006 then SQL has no problem in knowing which is the day of the month and which is the month.

Regards,
Phillip