date formet [message #202545] |
Fri, 10 November 2006 05:14  |
arunprabhu29917
Messages: 15 Registered: September 2006 Location: Tamilnadu
|
Junior Member |

|
|
how determine the first and last day for any specific week and month? in oracle query
thanks & regards,
Arunprabhu
|
|
|
|
Re: date formet [message #202555 is a reply to message #202547] |
Fri, 10 November 2006 06:07   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Or you could use TRUNC(date,'WW') and trunc(date,'MM') to get the first day of the week/month.
|
|
|
Re: date formet [message #202629 is a reply to message #202545] |
Fri, 10 November 2006 10:26   |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
And to be complete
First day of week - TRUNC(date,'WW')
Last day of week - TRUNC(date,'WW')+7
First day of month - trunc(date,'MM')
Last day of month - last_day(trunc(date))
If you are going to use them in a between then
First day of week - TRUNC(date,'WW')
Last day of week - TRUNC(date,'WW')+ 7 + (86399/86400)
First day of month - trunc(date,'MM')
Last day of month - last_day(trunc(date)) + + (86399/86400)
|
|
|
|