|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
December 13th, 2005, 09:45 AM
|
|||
|
|||
|
timestamps
I have a column that is of datatype timestamp. I need to set tha value of this column to current date + x number of minutes I pass in to it. I am trying the following, but get and error when I compile it:
NEXT_SEND_TIMESTAMP = (CURRENT TIMESTAMP + v_Minutes MINUTES) Error: During SQL processing it returned: SQL0182N An expression with a datetime value or a labeled duration is not valid. LINE NUMBER=95. SQLSTATE=42816 Could someone please help me with this. Thanks!
|
|
#2
December 14th, 2005, 12:33 PM
|
||||
|
||||
|
Can you dump the contents of the sql statement in order to see what is actually being sent to the database?
|
|
#3
December 17th, 2005, 07:20 PM
|
|||
|
|||
|
Off the top of my head - not sure - here is something every DB2 programmer should have:
http://ourworld.compuserve.com/homepages/graeme_birchall/HTM_COOK.HTM I have a printed copy in a binder at work - makes for an excellent quick reference to DB2 functions, etc. My first stop when I cannot remember the exact function or syntax needed to accomplish a task. fv
__________________
...because that is the way we have always done it. We've been doing it like that for 80 Years! (How do we change that mindset?)
|
|
| Viewing: Dev Shed Forums > Databases > DB2 Development > timestamps |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
