insert date to sql

thanks manoj
i will try your codes

Hey....
First create table in database
datatype should be datetime
create table date
(
DateOfBirth datetime
)
and write code on button event:
string database=ConfigurationManager.ConnectionString["you declred in webfile stringName"].connectionString;
SqlConnection con = new SqlConnection(database);
try
{
con.Open();
SqlCommand  cmd = new SqlCommand("Insert into date(datetime)values("@datetime")");
cmd.Parameter.Add("@datetime",sqldbtype.datetime).values=txtdatetime.Text();
cmd.ExecuteNonQuery();
response.write(true);
}
catch(Exception ex)
{
throws ex;
}
Finally
{
con.Close();
}
}
May be helpfull for you...
 
 
 

Forget all the other attempts at answering your question, the reality is that how it is being stored in 2005 Express is absolutely correct.  If you want to store dates the way you want to, then you have to define a VARCHAR or NVARCHAR in your database then you can store your dates any way that you want to  BUT then you will need to handle ALL date conversions to EVERY region that your application may execute in.

The reason that dates should be stored yyyy-mm-dd is really really obvious, it is done this way to eliminate ALL the problems like having to find out what region the computer is in and reading regional settings and testing for how the user enters dates and how you will display dates and how you will save them. 

It is not that difficult to convert a date to a string formatted to the way that you want to see it, you just need to learn how to do it programatically, it is really very simple...

u can try it out this way..
when u r inserting it in to ur table u can convert it  and then insert
declare @birthday as datetime
-- pass ur birthday date from ur datepicker to this variable from ur front end
set @birthday =getdate()
insert into table_name(column_name)
values
(
convert(char(11),@birthday,113)
)
 
output  will be : 29 Dec 2009 
  
 *****************************************************************************
Please mark it Accepted if u find it helpful.

hii hiren
i tried your way as well..
but still i dont get the format as i wish
as i see our codes are almost similar
i dont know if i should write some codes in sql server ??

hiii kirtan thanks for the reply
i tried what i see in the screenshot and my regional setting already same with the screenshot view
but still i see the dateformat like 2009.12.29
any other suggestion u have ?

Friend,


Here  I m giving your Solution

if my answer helps you then check "Do you like this answer" check box :)

you dont need to do any thing with the code or no need to Convert Column Data type to varchar etc :)

just go to

Control Panel >> Regional Settings >> Change the Date Format there

after that SQL Server will change the DateFormat Automatically in data:) See below Screen Shot

thanks for the reply man
but we would use here the date as string isnt it...so i have to convert it to DateTime when i want to compare to dates or i am wrong ??