| Author |
Message
|
| LearningMB |
 Posted: Wed Jan 22, 2014 5:55 am Post subject: difference between to timestamps |
 |
|
Newbie
Joined: 21 Jan 2014
Posts: 9
|
I am trying the following. But the debugger stops at the last line and does not move forward at all. Please let me know the correct way to achieve this.
Declare PutTime INTERVAL;
SET PutTime = (CAST(CURRENT_TIMESTAMP AS TIMESTAMP) - CAST(OLD_TIMESTAMP AS TIMESTAMP)) SECOND; |
|
| Back to top |
|
 |
| bruce2359 |
| Posted: Wed Jan 22, 2014 5:59 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
What debugger ?
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| LearningMB |
| Posted: Wed Jan 22, 2014 6:13 am Post subject: |
|
|
Newbie
Joined: 21 Jan 2014
Posts: 9
|
While i debug the code in message broker toolkit. It's the MB's debuggger
EDIT by exerk: Please post in the correct forum next time, thank you. Moved to the more appropriate forum. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jan 22, 2014 6:29 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Why are you casting the CURRENT_TIMESTAMP into a timestamp?
Why are you using the debugger when the debugger isn't working? Why have you not switched to taking a user trace so as to identify the problem which is causing the debugger to hang?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| dogorsy |
| Posted: Wed Jan 22, 2014 6:35 am Post subject: Re: difference between to timestamps |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
| LearningMB wrote: |
Please let me know the correct way to achieve this.
|
You should either read the documentation or have some formal training. |
|
| Back to top |
|
|
|
|
