Insert DB error with datetime format, but works after resubmit

Question

Hi,

I have a logic app launch half year already but got strange problem today.

I declare a var call "now" which is current time

but I got error message when I insert to my DB

  "body": {  
        "status": 400,  
        "message": "Conversion failed when converting date and/or time from character string.\r\nclientRequestId: 2f3044a5-6c07-4861-88c1-6692b78b07ba",  
        "error": {  
            "message": "Conversion failed when converting date and/or time from character string."  
        },  
        "source": "sql-ea.azconn-ea.p.azurewebsites.net"  
    }  

but when I click "resubmit" for this record on history blade, It will works without any problem.

can anyone tell me how can I resolve this problem ?

thanks

Ping

Answer 1

I got the same issue too, it doesn't work even I use utcNow()