|
View previous topic :: View next topic
|
| Author |
Message |
pinomaiulis
New User
Joined: 08 May 2006
Posts: 6
Location: Italy
|
|
|
|
Do any one have idea how to obtain list of all days in a month
using DB2 given functions? |
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi There,
| Quote: |
| how to obtain list of all days in a month |
What do u mean by that ?
Please provide example? |
|
| Back to top |
|
|
pinomaiulis
New User
Joined: 08 May 2006
Posts: 6
Location: Italy
|
|
|
|
| guptae wrote: |
Hi There,
| Quote: |
| how to obtain list of all days in a month |
What do u mean by that ?
Please provide example? |
I would like to obtain all the days of a specific month by a single select.
example:
Select "list of the days"
from sysibm.sysdummy1
where month(current date) = 11 |
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi There,
What do u mean list of days? |
|
| Back to top |
|
|
pinomaiulis
New User
Joined: 08 May 2006
Posts: 6
Location: Italy
|
|
|
|
| guptae wrote: |
Hi There,
What do u mean list of days? |
Query Result:
01.11.2006
02.11.2006
03.11.2006
04.11.2006
05.11.2006
06.11.2006
..
..
..
30.11.2006
Thank you |
|
| Back to top |
|
|
Garpen
New User
Joined: 03 Jan 2007
Posts: 14
Location: Sweden
|
|
|
|
Hi
I curious, how should the SQL look like ? |
|
| Back to top |
|
|
|
|
