[development-axapta] datetime conversation..

2004-01-02 Thread Anil Ozay
Hi all.. I run sql code from Axapta.. My code is : Connection Con; Statement Stmt; ResultSet R; Con = new Connection(); Stmt = Con.createStatement(); sqlString = "SELECT * FROM GET_EMPLOYEE_PRIMS WHERE DSEMPLID='A1' AND DATAAREAID='" + curExt() +"' " + " AND TR

Re: [development-axapta] datetime conversation..

2004-01-02 Thread Jonathan St-Louis
t the date like 29/09/2001. Hope it'll help. - Original Message - From: "Anil Ozay" <[EMAIL PROTECTED]> To: "Development-Axapta (E-mail)" <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 10:54 AM Subject: [development-axapta] datetime conversation..

Re: [development-axapta] datetime conversation..

2004-01-02 Thread Holger K. Pedersen
+ " AND TRANSDATE> CAST('"+date2str(str2date("29/09/2003",123),321,2,3,2,3,4)+"' AS datetime)"; R = Stmt.executeQuery(sqlString); /holgerkp :-) From: "Jonathan St-Louis" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: <[EMAIL PR