NEST is adding TimeZone while indexing docs in Elasticsearch

Question

I have a DateTime field in my c# class as below

 public DateTime PassedCreatedDate { get; set; }

While indexing it from NEST to elasticssearch, it is saving it along with local timezone. How to avoid this?

 "PassedCreatedDate": "2015-08-14T15:50:04.0479046+05:30" //Actual value saved in ES
 "PassedCreatedDate": "2015-08-14T15:50:04.047" //Expected value

mapping of PassedCreatedDate in elasticsearch is

  "PassedCreatedDate": {
                  "type": "date",
                  "format": "dateOptionalTime"
               },

I am aware to have a field as string and provide the format in ElasticProperty, but is there any setting to avoid this timezone addition while using datetime field only?

Why do you want to exclude the timezone offset?

Russ Cam
– Russ Cam

2015-08-24 22:21:25 +00:00
Commented Aug 24, 2015 at 22:21 — Russ Cam
– Russ Cam, Commented Aug 24, 2015 at 22:21

Russ Cam · Accepted Answer · 2015-08-24 22:28:07Z

3

There are two things to change to achieve saving DateTimes without the time zone offset.

Firstly, NEST uses JSON.Net for json serialization, so we need to change the serializer settings on the ElasticClient to serialize DateTimes into the format desired, and interpret those DateTimes as Local kind when deserializing

var settings = new ConnectionSettings(new Uri("http://localhost:9200"));

settings.SetJsonSerializerSettingsModifier(jsonSettings => 
{
    jsonSettings.DateFormatString = "yyyy-MM-ddTHH:mm:ss",
    jsonSettings.DateTimeZoneHandling = DateTimeZoneHandling.Local
});

var connection = new InMemoryConnection(settings);
var client = new ElasticClient(connection: connection);

Secondly,we need to tell Elasticsearch via mapping, the format of our DateTime for the field(s) in question

"PassedCreatedDate": {
    "type": "date",
    "format": "yyyy-MM-ddTHH:mm:ss"
},

answered Aug 24, 2015 at 22:28

Russ Cam

126k34 gold badges211 silver badges275 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ibrahimozgon Over a year ago

SetJsonSerializerSettingsModifier doesn't exist in NEST 7.8.1 version :/

mx fan · Accepted Answer · 2024-02-29 02:16:20Z

0

For NEST 6.X and onwards,things have changed a bit.

Now you need 2 steps to achieve serializer settings .

1.Import NEST.JsonNetSerializer ,with a version identified with your NEST version.

2.

 var settings = new ConnectionSettings(pool, sourceSerializer: (builtin, settings) => new JsonNetSerializer(builtin, settings, () => 
                    new JsonSerializerSettings
                    {
                        DateFormatString = "yyyy-MM-dd HH:mm:ss",
                        DateTimeZoneHandling = DateTimeZoneHandling.Local
                    })
                )

refering to nest doc here

answered Feb 29, 2024 at 2:16

mx fan

112 bronze badges

Collectives™ on Stack Overflow

NEST is adding TimeZone while indexing docs in Elasticsearch

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related