# Translate sql query

**URL:** <https://discuss.elastic.co/t/translate-sql-query/203827>\
**Category:** Elasticsearch\
**Created:** [October 16, 2019, 12:07pm UTC](https://discuss.elastic.co/t/translate-sql-query/203827 "2019-10-16T12:07:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Masdi](https://avatars.discourse-cdn.com/v4/letter/m/87869e/32.png) [@Masdi](https://discuss.elastic.co/u/Masdi)\
**Post date:** [October 16, 2019, 12:07pm UTC](https://discuss.elastic.co/t/translate-sql-query/203827/1 "2019-10-16T12:07:43Z")

</div>

Hi,

Is it possible to translate the month name from a datetime? For example, I would like to get the result in Spanish for this query: SELECT MONTH\_NAME(CAST('2018-02-19T10:23:27Z' AS TIMESTAMP)) AS month;

---

<div class="post-metadata">

**Author:** ![matriv](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matriv/32/43656_2.png) [@matriv](https://discuss.elastic.co/u/matriv)\
**Post date:** [October 16, 2019, 4:28pm UTC](https://discuss.elastic.co/t/translate-sql-query/203827/2 "2019-10-16T16:28:06Z")

</div>

Unfortunately this locale-aware functionality is not supported at the moment.  
I suggest that you create a github issue requesting it and see if we can include it in our roadmap.

Thank you!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 13, 2019, 4:28pm UTC](https://discuss.elastic.co/t/translate-sql-query/203827/3 "2019-11-13T16:28:11Z")

</div>

Closed on November 13, 2019, 4:28pm UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.