ansaurus

Question

How to get start and end dates of current month

Answer 1

A:

Use trunc( ... ) and last_day( ... ).

See also: Oracle Forums.

Dave Jarvis 2009-09-09 02:41:30

thanks for reply.it would be nice if I get query for H2 database

Lico 2009-09-09 02:46:56

Sorry, the question was tagged Oracle when I looked. ;-)

Dave Jarvis 2009-09-09 02:52:50

Answer 2

+1 A:

CURRENT_DATE[()] | CURDATE() | SYSDATE | TODAY = returns current date

Start of month:

DATE EXTRACT(YEAR FROM SYSDATE) +'-'+ EXTRACT(MONTH FROM SYSDATE) +'-01'

OMG Ponies 2009-09-09 02:50:42

Thanks for the reply. I want to get date from system rathor than a table.

Lico 2009-09-09 02:58:37

Updated to suit.

OMG Ponies 2009-09-09 03:09:21

I tried select DATEADD('MONTH', 1, SYSDATE)its giving me 2009-10-08 23:15:16.578...but I need first date (2009-10-01 00:00:00.000)of the current monthThanks!

Lico 2009-09-09 03:18:26

I'm going on record: H2 SQL is limited

OMG Ponies 2009-09-09 03:45:40

Answer 3

+1 A:

http://sqltutorials.blogspot.com/2007/06/sql-first-and-last-day-of-month.html

Only thing that isn't covered is how to retrieve the current date... see rexem's post.

Mayo 2009-09-09 03:25:36

Thanks a lot! Article explained what I needed to understand the logic behind for getting the desired date. Substract no. of days from current date.

Lico 2009-09-09 03:45:26

Answer 4

A:

For completeness, start of month:

DATE EXTRACT(YEAR FROM SYSDATE) +'-'+ EXTRACT(MONTH FROM SYSDATE) +'-01'

End of month:

DATEADD('DAY', -1, DATEADD('MONTH', 1, DATE EXTRACT(YEAR FROM SYSDATE) +'-'+ EXTRACT(MONTH FROM SYSDATE) +'-01'))

Cellfish 2009-09-10 03:30:25

ansaurus

tags:

views:

answers:

How to get start and end dates of current month

related questions