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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How can u convert the Date to String?

Question Posted / sivakumar

Answer Posted / sivakumar

Select convert(varchar(20),getdate()) As Date

Is This Answer Correct ?    5 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the function of inner join?

1004

What is difference between count (*) and count 1?

865

What are the recovery models for a database?

1057

What encryption security is available in sql azure?

99

What is merge statement?

1019

What is the tcp/ip port on which sql server runs?

1060

Explain in details security in SQL azure?

121

What is mean by dml?

945

If no size is defined while creating the database, what size will the database have?

923

How and why use sql server?

953

Does partitioning ssd reduce performance?

846

What are the differences between char and varchar in ms sql server?

998

Explain what is scheduled job and how to create it?

898

How many types of local tables are there in sql server?

887

What part does database design plays a role in performance of an sql server-based application?

926