date format for input parameters for SQLQuery

[Former Member]

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

[swaroop_anasane]

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

[Former Member]

Hi,

The DateTime Input can be in xml format :- 2016-04-28T16:50:00

Regards

Shikhil