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

What it means to be triggered?

908


Where sql server user names and passwords are stored in sql server? : sql server database administration

992


How to Update from select query in sql server?

992


Write the syntax for stuff function in an sql server?

976


Explain how to integrate the ssrs reports in application?

943


How to get a list of all tables with "sys.tables" view in ms sql server?

978


Sql server reporting services vs. Crystal reports.

118


What are ddl (data definition language) statements for tables in ms sql server?

1024


How does normalization work?

864


How can I check that whether automatic statistic update is enabled or not?

984


How to list all user defined functions in the current database?

970


What is store procedure?

1002


What is the difference between substr and charindex in the sql server?

998


Explain an automatic checkpoint

908


How do I run a trace in sql server?

928