I am still confused...<BR><BR>i want to select a date from a table. but when i write a query like select date from tabelname then its displaying date and time both. i want only date and not time.<BR>e.g. tabelname = Orders<BR> colomnname = creation_date<BR> query = select creation_date from Orders;<BR>now i am getting date and time both here. but my requirement is just to get date and i don't want to display time. <BR>How should i write a query in sql server?<BR><BR><BR><BR>
ya when you decalre the datatype in the sqlserver as a datatime or smalldatatime the time is even captured along with the date and so when you open the resultset you will get the time part even wht you can do is after opening the resultset before diplaying those data you can format the display so that you dont display the time.