nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

problems saving datetime to SDE via applyedits

JustinClowes

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, ........

Find more posts tagged with

Accepted answers

martinschmoll

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

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

All comments

JeffPace1

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

JustinClowes

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

JeffPace1

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

martinschmoll

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()
};

JustinClowes

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

JeffPace1

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

martinschmoll

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

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.