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
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..
+ " 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
3 matches
Mail list logo