What is difference between Datepart() and Datename() in SqlServer?

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

What is difference between Datepart() and Datename() in SqlServer?

Question Posted / raj kumar baghel

0 Answers
1156 Views
Infosys, I also Faced
E-Mail Answers

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Can you roll back the ddl statement in a trigger?

Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers ASD Lab,

What does it mean to normalize data?

Do you know what is xpath?

What is bcp? When does it use?

Can we use having clause without group by?

Explain few examples of RDBMS?

0 Answers Wipro,

What are the requirements for sql server 2016?

Explain the properties of the relational tables?

Does union all remove duplicates?

What is mean by dml?

How to link tables in sql server?

For more SQL Server Interview Questions Click Here

Categories

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)