skip to main | skip to sidebar

SqlQueries

SQLQueriesCollection is blog for all sql queries in SqlServer at one place.SQL,SQL Query,SQL Queries,SQL Query Code,SQL Query Example,SQL Query Syntax,Basic Sql Queries,Query,SQL Examples,SQL Basic Queries,Structured Query Language.

Query to get only month from particular date

Query to get only month from particular date
select month(datecolumnname)as month from tablename

Posted by sqlqueries

Labels: Query to get only month from particular date, slq queries

0 comments:

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Recent Posts

Movies Songs
BeautifulPictures
Sql Server Faqs
Software Testing
CheckVocabulary

Enter your email address:

Delivered by FeedBurner

Blog Archive

► 2009 (10)
- ► June (1)
  - SQL Query To Drop a Table in SQL Server
- ► May (1)
  - SQL Query to Return Information about a single dat...
- ► April (4)
- ► February (2)
  - SQL Query To Find Minimum Salary From Emp Table in...
  - SQL Query To Find Maximum Salary From Emp Table in...
- ► January (2)
  - Sql Query to Retrieve Nth Highest Salary From Ta...
  - How to Retrieve a Random Record from a Table in Sq...

▼ 2008 (20)
- ► December (4)
- ► November (1)
  - SQL Query to Rename Column Name in SQL Server-Quer...
- ► April (2)
  - sql query for second highest salary in oracle
  - Sql query for top 5 records in oracle
- ▼ March (8)
- ► January (5)