Micros isl - Inconsistency in data queries

[JCCR]

Hello to all

I am consulting the micros database from a script and when I receive the data instead of receiving 2020/11/23 12:13:43.0 I receive 2020//11//23 12/:13/:43.0, that is to say a "/" character is added to the string in each occurrence of a "/" or a ":", this happens to me if the origin field is of datetime or varchar type, I perform the consultations using the DLLCall_CDECL command. I have the following configuration in my server

Windows 10 Pro
Micros Res POS 3700 5.7.6.4

 

[CathalMF]

It would be useful if you posted the script or a small example that we can install and replicate the issue.

Specialist in creating custom applications for the Micros POS range: 3700, 9700, Simphony FE, Simphony. SIM Scripts, Data Exports, Simphony extension applications, API Creation and integration. If you need anything please contact me via my website

http://www.microspostools.com/