Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How can u convert the Date to String?

Answer Posted / prasad

select convert(varchar,columnname,101) from tablename

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2058


What is a periodical index?

904


how to create “alternate row colour”?

146


How to disconnect from a sql server using mssql_close()?

1083


what are cursors? : Sql server database administration

1039


What is data source document?

1015


How to install sql server 2005 express edition?

1098


What is mssql?

975


How to delete all rows with truncate table statement in ms sql server?

976


Describe in brief system database.

999


What is a self join in sql server?

1110


What is the difference between web edition and business edition?

111


What is the maximum size of a dimension? : sql server analysis services, ssas

1025


you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

1022


Explain where clause?

977