topic Re: problems saving datetime to SDE via applyedits in ArcGIS JavaScript Maps SDK Questions

problems saving datetime to SDE via applyedits

JustinClowes — Thu, 06 Feb 2014 15:25:31 GMT

I'm trying to create a new feature using featureLayer.applyEdits.
I pass in the geometry and attributes and this is saved to the database correctly.
When I try and save a datetime attribute I get the error : "Error saving new find : Unable to complete operation".

Does anyone know what format the datetime needs to be in?

I am using ArcGIS Server v10 with SQL Server 2008.
Thanks. See my code below:

var datetime = dojo.date.locale.parse("07/02/2014 13:54",
        {
                datePattern:"dd/MM/yyyy",
                timePattern:"HH:mm"
        }
);

var attr = {
"DATE_TIME_J" : datetime
};

var ng = new esri.Graphic(Point, null, attr, null);
featureLayer.applyEdits([ng], null, null, ........

Re: problems saving datetime to SDE via applyedits

martinschmoll — Thu, 06 Feb 2014 17:12:54 GMT

I use the .valueOf() function to pass the current date into Oracle via applyEdits() on a FeatureService:

... "DATETIME": new Date().valueOf(); ...

Re: problems saving datetime to SDE via applyedits

JeffPace — Thu, 06 Feb 2014 17:45:31 GMT

I'm trying to create a new feature using featureLayer.applyEdits.
I pass in the geometry and attributes and this is saved to the database correctly.
When I try and save a datetime attribute I get the error : "Error saving new find : Unable to complete operation".

Does anyone know what format the datetime needs to be in?

I am using ArcGIS Server v10 with SQL Server 2008.
Thanks. See my code below:

var datetime = dojo.date.locale.parse("07/02/2014 13:54",
        {
                datePattern:"dd/MM/yyyy",
                timePattern:"HH:mm"
        }
);

var attr = {
"DATE_TIME_J" : datetime
};

var ng = new esri.Graphic(Point, null, attr, null);
featureLayer.applyEdits([ng], null, null, ........

if the field you are trying to write to a date field? or a string

Re: problems saving datetime to SDE via applyedits

JustinClowes — Fri, 07 Feb 2014 12:02:17 GMT

thanks, yes I'm trying to write to a datetime field (in SQL Server) and I need to include both the date and the time.
I need to write a specific date + time, not the current date

Re: problems saving datetime to SDE via applyedits

martinschmoll — Sat, 11 Dec 2021 08:19:25 GMT

I need to write a specific date + time, not the current date

I thought it was obvious, but the valueOf() function can be used on any date! We use Oracle, and this was the solution for us. So in your example try:

var attr = {
"DATE_TIME_J" : datetime.valueOf()
};

Re: problems saving datetime to SDE via applyedits

JeffPace — Fri, 07 Feb 2014 19:39:35 GMT

mschmoll is is right

By passing datetime, you are actually sending the parsed string to the database

but using valueof(), you are likely sending the actual datetime value

Re: problems saving datetime to SDE via applyedits

JustinClowes — Mon, 10 Feb 2014 07:31:41 GMT

Thanks, that works perfectly with SQL Server too. Problem solved.

Re: problems saving datetime to SDE via applyedits

JeffPace — Mon, 10 Feb 2014 11:18:55 GMT

great to hear! please mark mschmoll's post as the answer by checking the checkmark on his post so he gets credit for it.