LAST_DAY returns the last day of the month in which a particular date falls.
LAST_DAY
Return Value
DATE
Syntax
LAST_DAY(date)
Arguments
date can be any datetime expression.
date
Example
LAST_DAY('26-MAR-06') returns the value 31-MAR-06.
LAST_DAY('26-MAR-06')
31-MAR-06
subject
from Anonymous
Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.
Scripting on this page enhances content navigation, but does not change the content in any way.
Quick Lookup
Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages
Main Categories
This Document