Getting Last Day of Previous Month in Oracle Function

database oracle function date-arithmetic
Soner Gönül picture Soner Gönül · Feb 10, 2011 · Viewed 65.8k times · Source

I need a function in Oracle like this.

When i giving a parameter a simple date. Then function should getting me last day of the previous month.

Example: 

FunctionName(10.02.2011) Result should be 31.01.2011

FunctionName(21.03.2011) Result should be 28.02.2011

FunctionName(31.07.2011) Result should be 30.06.2011 (Even date is last day of month)

How can i do that? By the way, i never use Oracle .

Answer

Lamak picture Lamak · Feb 10, 2011 
SELECT LAST_DAY(ADD_MONTHS(yourdate,-1))

Related questions

How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: SQL Server …

Read More
How can I get column names from a table in Oracle?

I need to query the database to get the column names, not to be confused with data in the table. For example, if I have a table named EVENT_LOG that contains eventID, eventType, eventDesc, and eventTime, then I would …

Read More