Advance thanks ....... 

My table is  TimeSheet:
----------------------------------- 

 CREATE TABLE [dbo].[TimeSheet](
    [autoid] [int] IDENTITY(1,1) NOT NULL,
    [UserId] [int] NOT NULL,
    [starttime] [datetime] NOT NULL,
    [endtime] [datetime] NOT NULL,
    [summary] [nvarchar](50) NOT NULL,
    [description] [nvarchar](50) NULL,
    [dtOfEntry] [datetime] NOT NULL,
    [Cancelled] [bit] NULL
) ON [PRIMARY]

My Query is
------------------
insert into timesheet
(UserId, StartTime,EndTime, Summary, Description,DtOfEntry)
 values (2, '19/04/2008 2:05:06 PM', '19/04/2008 2:05:06 PM', '66', '6666','19/04/2008 2:05:06 PM')

i m not able to insert value 

Error Message is
-------------------------
Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.

 
can any body give any solution 

 When inserting datetimes, the format of the date time string is very important. The format of the date is dependant on the culture of your operating system and what collation the database is configured to be.

In most default instances it will just be yyyy-MM-dd hh:mm:ss

so try this

insert into timesheet
(UserId, StartTime,EndTime, Summary, Description,DtOfEntry)
 values (2, '2008-04-19 2:05:06 PM', '2008-04-19 2:05:06 PM', '66', '6666','2008-04-19 2:05:06 PM')

in database, dateformat wil have to be like, yyyy,mm,dd

eg: '2008/04/19 2:05:06PM' //this will work

when you givw, 19/04/2008, then it will think that date is 2008, so it is giving error "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."

 thanks for ur reply..................

now i have change date format and its working............ 

 Hi ,

 i m inserting the values in the fallowing ways 

INSERT INTO LoginHistory([UserID],[LoginTime],[LoginIP])VALUES('NilCom1Ad01','13-04-2009 4:52:54 PM','127.0.0.1' )

 Still i  m Geting errror

 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.

Can u help me 

jimmy q:

In most default instances it will just be yyyy-MM-dd hh:mm:ss

There are 2 un-ambiguous date formats that SQL Server will NEVER mis-interpret.

yyyy-mm-ddThh:mm:ss  (The T is a literal and must appear along with the data).  Ex: "2008-04-19T14:05:06"

OR

yyyymmdd h:mm:ss  Ex: "20080419 14:05:06"

I prefer the second method because it is 'less strict' with the time data.  In the first format, you must use military time and the hour must be zero padded.  With the second format, the hour does not need to be zero padded and does not need to be in military format.