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

[martinschmoll · Accepted solution]

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

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

[JeffPace]

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

[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

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

[JeffPace]

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

[JustinClowes]

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

[JeffPace]

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