insert only date

[m dhu]

can we insert only date (mm/dd/yyyy) using smalldatetime(mm/dd/yyyy 00:00:00) as datatype.. into sql table as i used this to select..

select (CONVERT(CHAR(10), date, 101)) as date

[Christian Graus]

You can if you want, but it looks to me like you're trying to store it as a string instead of a date. That would be stupid.

Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

[m dhu]

i tried this

insert into news(date) values (CONVERT(char(10), 2001-01-01, 101))

but still it is 2001-01-01 00:00:00

[Nisha Agrawal]

If you are using sql server 2008 then there is a data type date for this purpose. you can use that.

[Christian Graus]

A datetime has a time component. IF you want to work only with dates, just ignore the time part, and set it to 0:0:0 for all values.

Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

[m dhu]

im using sql server 2005...

[Lost User]

madhukk wrote:

im using sql server 2005...

It's just the same; like I told you yesterday, store your dates as date values not as strings. Then, when you want to display them or print them you can format them any way you like, in any order, with or without the time.

[m dhu]

i stored in date itself but i want seperate into three dropdownlists ddl1(mm) ddl2(dd) ddl3(yyyy)

string final = Session["startdate"].ToString();
DateTime dt;
dt = Convert.ToDateTime(final);
final = dt.Day + "/" + dt.Minute + "/" + dt.Year;
TextBox1.Text = final;
// i got mm/dd/yyyy

DropDownList5.SelectedItem.Text = dt.Day.ToString();
Object reference not set to an instance of an object.

what im i doing wrong????

[Lost User]

madhukk wrote:

what im i doing wrong????

Well your main problem suggests that either DropDownList5 or its SelectedItem property do not have a valid reference. Also you have dt.Minute where you want the month. Lastly, you still seem to be wasting processing on converting DateTime values to and from String values when it is not necessary. I would be tempted to rewrite the above (assuming Session["startdate"] returns a DateTime value) :

    DateTime dt = Session\["startdate"\];
    TextBox1.Text = dt.ToString("dd/MM/yy");

DropDownList5.SelectedItem.Text = dt.Day.ToString();