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

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,

Advertisements

Find Day of Month

Mysql last day of month

Get Last Day of The Month

is this programm efficient to find the day of the given date . can it be more normalized ?

how to find the given date is sunday

Day for the given Date in Java

Write a program to find a factorial in any given number

Output Previous or Next Day of the Month

How to find java jobs at any where in india

Find out last character of array

Find Month name using DateFormatSymbols class.

ModuleNotFoundError: No module named 'odoo8-addon-contract-recurring-invoicing-monthly-last-day'

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

ModuleNotFoundError: No module named 'mysqlx-connector'

find the given input is integer or string

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

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

Finding Last Modification Date of a file

PHP MySQLi

How to Addding One Month with PHP ?

PHP MySQLi Affected Rows

Java converts any given year to Roman Numeral

Mysql Date Month

How to get day of week in Java?

Find the Day of the Week

How to get the Day name

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

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

find factorial of any number using recursion

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

How to get day from date in Java using Calendar?

Get first day of week

How to learn Java programming in a month

How can I master Java in one month?

Hibernate 5 MySQL5 Dialect

Find Zodiac Sign

How long will data Science last?

How to change day to night scene, change day to night scene, day to night scene

C file Last Modified Date

Write a program to calculate factorial of any given number

Java file last modified date

jdbc mysqll - JDBC

PHP MySQLi Query

how to create month wise serial number in java?

Java Get Month from Date

Ads