IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


Is this sql query will execute in db2?



IBM's flagship relational database management system
Post a reply

Is this sql query will execute in db2?

Postby Selvaraj » Thu Dec 23, 2010 1:44 pm

The following query will execute or return values from table ?
SELECT DATE+4 FROM TABLE
Selvaraj
 
Posts: 9
Joined: Wed Dec 22, 2010 9:09 pm
Has thanked: 0 time
Been thanked: 0 time
Top

Re: Is this sql query will execute in db2?

Postby GuyC » Thu Dec 23, 2010 2:22 pm

only if "date" is a numeric (int,dec,float) column of the table.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times
Top

Re: Is this sql query will execute in db2?

Postby kk12345 » Sun Dec 26, 2010 10:02 pm

Hi Selvaraj,

Visit the link below for more information on DATEs
http://www.ibm.com/developerworks/data/ ... 1yip3.html
kk12345
 
Posts: 18
Joined: Sun Dec 26, 2010 6:26 pm
Has thanked: 0 time
Been thanked: 0 time
Top
Post a reply

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks