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

Finde mehr Beiträge mit dem Tag

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

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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