|
View previous topic :: View next topic
|
| Author |
Message |
chrakesh
New User
.jpg)
Joined: 03 May 2010
Posts: 16
Location: india
|
|
|
|
Hi how can i find whether some specific date suppose dome Due_date is between the following Sunday 12 am and next week Saturday 11:59 pm .
can anyone suggest a sql query for this. |
|
| Back to top |
|
 |
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
| Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004
Posts: 551
Location: Bangalore
|
|
| Back to top |
|
|
chrakesh
New User
Joined: 03 May 2010
Posts: 16
Location: india
|
|
|
|
| Can anyone help me on this query, how can we write the specific query? |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
You should be able to figure it out by yourself, by reading the stuff.
a date is not between timestamps,
a specific timestamp is between next sunday, 12am and following saturday,23:59 pm
a specific date is between next sunday and following saturday
| Code: |
select
current_date + (7 - dayofweek_iso(current_date)) days,
current_date + (13 - dayofweek_iso(current_date)) days,
timestamp(current_date + (7 - dayofweek_iso(current_date)) days,'00:00:00'),
timestamp(current_date + (13 - dayofweek_iso(current_date)) days,'23:59:59')+ 999999 microseconds
from sysibm.sysdummy1 |
|
|
| Back to top |
|
|
chrakesh
New User
Joined: 03 May 2010
Posts: 16
Location: india
|
|
|
|
| Thanks man.... |
|
| Back to top |
|
|
|
|
