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 out some of the requirements to set up a sql server failover cluster?

1081


What is the purpose of indexing?

1091


How can we delete Duplicate row in table?

1114


In what sequence sql statement is processed?

1057


What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1353


Is sql server difficult to learn?

968


What are the new features of sql server 2012 reporting service?

141


Can you import Microsoft Excel data to SSRS?

135


What is temporal data type?

967


Can a table be created inside a trigger?

1014


How to loop through result set objects using mssql_fetch_array()?

1137


What stored by the msdb? : sql server database administration

1053


what are the different ways to return the rowcount of a table?

1055


What does it mean if @@cursor_row returns a negative number?

1039


How to download and install microsoft .net framework version 2.0?

1184