Skip to content

Misc

Resolved: The Elasticsearch service terminated with the following service-specific error: Incorrect function.

If you are running an elastic search in your local environment or on a hosted environment you might come across the following error. You can view this error in Event Viewer and System logs. The Elasticsearch 5.5.3 (Elasticsearch5.5.3) service terminated with the following service-specific error:Incorrect… Read More »Resolved: The Elasticsearch service terminated with the following service-specific error: Incorrect function.

Compare dates in SQL

A lot of times we come across issues comparing dates in SQL. There are a few scenarios below Compare dates in the DateTime Column Select * from EMP WHERE datetime_column >= ‘20221220 00:00:00.000’ AND datetime_column < ‘20221221 00:00:00.000’ Compare Day Year Month separately in DateTime… Read More »Compare dates in SQL