Search results for query: *

I am using QMF to convert a character type into a date type. Is this possible, if so how? I have tried a few things but the recent is SELECT DATE(ROUTE_DT) FROM INVOICE; The error message I am receiving is the datetime value is invalid.

I am using QMF to convert a character type into a date type. Is this possible, if so how? I ahve tried a few things but the recent is SELECT DATE(ROUTE_DT) FROM INVOICE; The error message I am receiving is the datetime value is invalid.

THANKS so much for all of your help, I am going to try the DECIMAL datatype. I really appreciate it.

Is NUMBER a valid DB2 datatype? I am not sure?

I have the column currently set as a character datatype and I am receiving the error, new value has wrong data type. I don't understand why character would be the wrong data type, should I try integer?

Is there a similar way to do a datediff function in DB2?

Is there a way to perform a date diff function in DB2? If so how?

My question is that when I update that column does it need to be of a date type, I currently have the column as a character type and I am receiving and error: New value has wrong data type. I am using a DB2 database.

I am trying to get the date difference between a date in a DB2 column and today's date and updating it to a column. The column type that I am updating it to is character. I am getting an error, new value has wrong data type when trying this SQL statment. UPDATE W17G.INVOICE SET...

Does anyone know how I can perform function in SQL that will subtract the current date from a date in a specific column. What I really want to do is a date difference function and then update the difference to a column. Any suggestions?

I figured it out late last night after a number of hours but what you want to do is a subquery within the UPDATE statement. UPDATE W17G.INVOICE SET REV_ROLE = 'CS' WHERE ROUTE_LST =...

Are you not able to use a reference to another table when executing an update procedure. I am trying to update a column but I am getting errors in my SQL statement. I am using a DB2 database. My example: UPDATE W17G.INVOICE SET REV_ROLE = 'CS'...

I am trying to use the UPDATE statement to update a table that currently has data. There is a column "QUEUE_DT" that I need to update using the data currently in the table. I would like to do something like this: UPDATE INVOICE SET QUEUE_DT = SCE5200.APROVQUECREATEDT FROM SCE5200...