on 04-28-2016 5:10 PM
Hi,
I'm new to MII. I have a stored procedure in MS SQL Server that takes a DateTime parameter as input.
What format should I use when I run the SQLQuery in MII Workbench? The MII SQLQuery simply does exec spTest [Param.1] [Param.2]
Any help is greatly appreciated!
/BR
Jonas
Hi Jonas,
It can expect parameters in format like MM/dd/yyyy HH:mm:sswhich can further be modified to suit query requirements using date format in general tab of query template.
Further, please refer the link below:
Query Parameter Types - SAP Manufacturing Integration and Intelligence - SAP Library
Regards,
Swaroop
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The DateTime Input can be in xml format :- 2016-04-28T16:50:00
Regards
Shikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
10 | |
5 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.