|
View previous topic :: View next topic
|
| Author |
Message |
abdulrafi
Active User
Joined: 14 Sep 2009
Posts: 184
Location: Coimbatore
|
|
|
|
Hi,
I need to add 24 hrs to my current timestamp and place it in a working storage variable.
I tried the below one, but its not working. Could you please help me on this.
Exec sql
Set :ws-timestamp = current timestamp + time(24,0,0)
End-exec |
|
| Back to top |
|
 |
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
|
|
| Code: |
CURRENT TIMESTAMP + 24 HOURS
or
CURRENT TIMESTAMP + 1 DAY |
|
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
| Back to top |
|
|
|
|
