I am trying to do a select and set the time to 10AM in DB2. Ive tried however this sets the time to 0:00:00, im trying to get it set to 10AM, is there a way to do this in DB2? Answer Please can you try this: Here is the DEMO Also, in your question example you have one open
Tag: db2-400
DB2 query with multiple WITH AS cases not compiling
For some reason, I can’t get this query to perform as I’m getting an error: Token ( was not valid. Valid tokens: , FROM INTO. I’m running this in DB2 and I think this is occurring at either the very …
Add a column to a DB2/400 table with a specific ordinal position
Is there an SQL command on the AS400/iSeries/System-i/whatever to add a column to a table in a specific ordinal position, or moving an existing column to a different position? Answer IBM i 7.1 now allows you to add a column in front of another. ALTER TABLE table ADD COLUMN colname … BEFORE othercolumn