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 / deepak rohilla

select convert(varchar(20),getdate())

Is This Answer Correct ?    5 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List the advantages of using stored procedures?

997


Explain an incremental backup?

937


What are the drawbacks of reporting in ssrs?

141


How to insert data with null values?

970


What is truncate table?

889


What is table value parameters (tvp)?

1037


How can we delete a table in sql server?

922


What is the command to change the recovery model?

999


What is meant by dirty read?

950


Which are the third-party tools used in sql server and why would you use them?

843


How can I create a new template for import ? : sql server management studio

1023


How will you decide the active and passive nodes?

1070


How to create a view using data from another view?

903


A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

904


How to Update from select query in sql server?

993