|
View previous topic :: View next topic
|
| Author |
Message |
chrakesh
New User
.jpg)
Joined: 03 May 2010
Posts: 16
Location: india
|
|
|
|
Hi Guys,
Can anyone please clarify this , Stored Procedure is not accepting '+' or '-' plus or minus symbols, for the following query.
Can anyone please provide me any alternative solution for this?
SELECT
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 |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| have you tried this select in spufi? |
|
| Back to top |
|
|
chrakesh
New User
Joined: 03 May 2010
Posts: 16
Location: india
|
|
|
|
Yes it executed successfully but it is saying
ILLEGAL SYMBOL "=". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: + - |
|
| Back to top |
|
|
murmohk1
Senior Member
.jpg)
Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India
|
|
|
|
| Quote: |
| FROM SYSIBM.SYSDUMMY1) |
I wonder how the SQL executed successfully in SPUFI? |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
1) quotes round : ‘23:59:59’ are the wrong kind
2) like murmohk1 says : one ) too many |
|
| Back to top |
|
|
|
|
