syntax to get dayname monthname day number in sql

HomePage Jobs WalkIn Articles Group Chat Contact Us Feedback Sitemap

	To improves our performance please Like Share Subscribe(Will boost us)
	Follow

syntax to get day name,month name,year,day number in sql
Question Posted on 27 Jul 2011Home >> DataBase >> SQL Query >> syntax to get day name,month name,year,day number in sql

---Syntax of Day Name
select datename(dw, getdate()) as DayName

---Syntax of Day Number
select datename(dd, getdate()) as DayName

---Syntax of Month Name
select datename(month, getdate()) as MonthName

---Syntax of Year
select datename(year, getdate()) as Year

	0
	0


	.

	Most Visited Questions:-
	Deep Learning Questions Answers Below are the different Deep Leaning Questions and answer a More...
	Continuous Integration Questions Answers Below are the 20 odd questions for CI or Continuous Integra More...
	Derived relationships in Association Rule Mining are represented in the form of __________. Derived relationships in Association Rule Mining are repres More...
	What is Gulpjs and some multiple choice questions on Gulp Gulpjs is an open source whihc helps in building Javascript More...
	Microservices Architecture Questions Answers Below are the different questions on Microservices Architec More...

Other Important Questions

How to get the table count in last used query from cache by sending tablename?

Write a SQL query to print 1 to 100 in sql server?

Sql Interview Latest Query questions asked on 30 dec 2020

nth highest number from table

some good sql query

To improves our performance please Like Share Subscribe(Will boost us)