Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Date Conversion
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. -
Date Conversion
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. -
DATE Function
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... -
Current Date
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? -
Update statement
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'... -
UPDATE a column using the value in another table
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...
