Page 1 of 1

Is this sql query will execute in db2?

PostPosted: Thu Dec 23, 2010 1:44 pm
by Selvaraj
The following query will execute or return values from table ?
SELECT DATE+4 FROM TABLE

Re: Is this sql query will execute in db2?

PostPosted: Thu Dec 23, 2010 2:22 pm
by GuyC
only if "date" is a numeric (int,dec,float) column of the table.

Re: Is this sql query will execute in db2?

PostPosted: Sun Dec 26, 2010 10:02 pm
by kk12345
Hi Selvaraj,

Visit the link below for more information on DATEs
http://www.ibm.com/developerworks/data/ ... 1yip3.html