Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Date add function in As400 db2 Expand / Collapse
Author
Message
Posted Monday, March 21, 2011 3:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 11, 2011 12:34 PM
Points: 1, Visits: 21
Can any one help me convert the SQl statement into a db2 statement
CAST(CONVERT(varchar, DATEADD(d, - (DAY(DATEADD(m, 1, GETDATE())) - 1), DATEADD(m, - 1, GETDATE())), 112) AS INT)


I av no knowledge abt the db2 database, kindly extend your help, thank you so much




Aaditya
Post #1081661
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse