Problem in inserting date for datetime field

[potlakayala]

I am inserting a row into database from asp.net. Below is the command i had given: insert_cmd = string.Format("Insert into CreateTask(AssignedTo,AssignedDate,EstimatedEfforts,Priority) values ('ABCD',14/08/2007,30,'Medium')"); The date i had given in the command is 14/08/2007, but when I check the table data in SQL server the date is displayed as ---- 1/1/1900 12:00:00 AM Please help me out... :(

Sailaja

[Rami Said Abd Alhalim]

this problem maybe cause format date if you need sure that set in command this date solve: insert_cmd = string.Format("Insert into CreateTask(AssignedTo,AssignedDate,EstimatedEfforts,Priority) values ('ABCD',08/14/2007,30,'Medium')");

[potlakayala]

Said could you plz tell me how to do that as i dnt know. i'm new to sql :(

Sailaja

[okdeshpande]

Insert into CreateTask(AssignedTo,AssignedDate,EstimatedEfforts,Priority) values ('ABCD','2007-8-11',30,'Medium' In VB u have format function. U can use this function to format the date. i.e. YYYY-MM-DD format.

[potlakayala]

thx pande... the code worked correctly if I give the date in single quotes but am not getting the current system time in it.. :( its displayed as: 8/14/2007 12:00:00 AM

Sailaja

[Pete OHanlon]

If you want to insert the current date and time, use the Getdate() function. It's a Sql Server function that returns the current date and time. For instance: insert into myTable(CurrentDate) values (GetDate());

Deja View - the feeling that you've seen this post before.

[potlakayala]

my problem has been solved. thank u so much... :rose:

Sailaja