Hi all,
I got data from SQL database as a collection, 3 of the fields are datetime(date time format) I am trying to add or update this field with new entries instead of updating this fields in one go I am doing each field to update individually when I try to update first one it is throwing an error some thing like this:
Incorrect syntax near ‘05’
Probably it's because I entered the date in one field ats11/17/2018 05:20:00 and other date field(11/17/2018 07:20:39) the error is like this:
Incorrect syntax near 07
We added manually to the date fields in collection current value it is throwing error as incorrect syntax 5 and 7 on respective fields so ,I thought it's because of format date so I used format date and make the time as HH:MM:SS as and as I said it throwed above error like incorrect syntax near 05 and 07 I. Respective fields
I got data from SQL database as a collection, 3 of the fields are datetime(date time format) I am trying to add or update this field with new entries instead of updating this fields in one go I am doing each field to update individually when I try to update first one it is throwing an error some thing like this:
Incorrect syntax near ‘05’
Probably it's because I entered the date in one field ats11/17/2018 05:20:00 and other date field(11/17/2018 07:20:39) the error is like this:
Incorrect syntax near 07
We added manually to the date fields in collection current value it is throwing error as incorrect syntax 5 and 7 on respective fields so ,I thought it's because of format date so I used format date and make the time as HH:MM:SS as and as I said it throwed above error like incorrect syntax near 05 and 07 I. Respective fields