how to find last day 0f any given month in mysql?

Latest Tutorials| Questions and Answers|Ask Questions?|Site Map

Home Answers Viewqa SQL how to find last day 0f any given month in mysql?

Login

QuestionAsk Questions?

shabla Habeeb

how to find last day 0f any given month in mysql?
2 Answer(s) 2 years and 7 months ago
Posted in : SQL

how to find last day of any given month in mysql?

View Answers

December 2, 2010 at 5:00 PM

Hi Friend,

Here is required code:

DECLARE @dtDate DATETIME
SET @dtDate = '8/18/2007'
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,@dtDate)+1,0))

Thanks

December 22, 2010 at 2:08 PM

hi, SELECT LASTDAY('2003-02-05')FROM tablename

thanks,

Related Pages:

how to find last day 0f any given month in mysql?

Find Day of Month

Mysql last day of month

Get Last Day of The Month

Mysql last day of month

Day for the given Date in Java

jdbc mysqll - JDBC

how to find the given date is sunday

Output Previous or Next Day of the Month

How to design a day and night process, design a day and night process, day and night process

Write a program to find a factorial in any given number

Find out last character of array

C file Last Modified Date

Finding Last Modification Date of a file

Get first day of week

Hi..How to Display Days by month - Java Beginners

PHP Date add 1 month

how to find subarray from given large 2d array of arbritary dimension

PHP MySQLi

Find Month name using DateFormatSymbols class.

Find Zodiac Sign

Find the Day of the Week

Java file last modified date

Mysql Date Last 30 Days

PHP MySQLi Affected Rows

MySQL add month

Same Day Taj Mahal Tour from Delhi to Agra

How to find java jobs at any where in india

How to Addding One Month with PHP ?

Transaction in last 3 months

PHP MySQLi Query

php show last query

PHP MySQLI Prep Statement

find factorial of any number using recursion

Same Day Taj Mahal Tour from Delhi

Java Get Month from Date

how to show x axis values of timeline chart in jfreechart with particular month.

JDBC: Last Inserted Id Example

Java get Next Day

Fleet Management of Medical vans/ambulance

Applet run with appletviewer but not in browser, any code problem.

Mysql Date Month

Find whether a date will be in the current quarter or the next quarter

How to find web hosting,find web hosting,right web host

plaz help me i try to compile from last 2 day .

plaz help me i try to compile from last 2 day .

Current Date iPhone SDK

Write a java program to display the season given the month using switch case

array find all possible dimension

find the given input is integer or string

Latest
Frameworks
Category