SQL: Implement to_char(date/time/datetime, pattern)

[matriv]

Implement to_char according to the PostgreSQL spec: https://www.postgresql.org/docs/9.1/functions-formatting.html by translating to the java.time patterns used in DATETIME_FORMAT.
Follows: #54832

[elasticmachine]

Pinging @elastic/es-ql (:Query Languages/SQL)

[avirlrma]

Hi, Can I start working on this?

[matriv]

@avirlrma Sure, go ahead!

[Boda805]

@avirlrma Are you still working on this? I would like to if not.

[matriv]

@Boda805 Since there is no response for some time, feel free to take it over if you want.

[Kasula11]

Hi matriv, I am new to open source. Can I take this?. Can you please tell me where to implement?

[matriv]

@Boda805 Are you still interested in taking this?

[Boda805]

@matriv Yes but I'm pretty busy for the next couple weeks, if @Kasula11 wants to take that's fine, I could still try to help out as well when I have time.

[Kasula11]

Thanks. When I am trying to import project as existing gradle project in eclipse. then it is showing me error.

Caused by: org.gradle.api.GradleException: At least Java 11 is required to build elasticsearch gradle tools
at build_6mm40yswivqsuj1oqx64fwsng.run(C:\Users\karthik\elasticsearch\buildSrc\build.gradle:66)
at org.gradle.groovy.scripts.internal.DefaultScriptRunnerFactory$ScriptRunnerImpl.run(DefaultScriptRunnerFactory.java:91)
... 155 more

Even though I have download Java 11 and Set JAVA_HOME to C:\Program Files\Java\jdk-11.0.6

Please Help me regarding this

[Boda805]

@Kasula11 use Java 14 I had the same problem at first. I believe it's in the documentation somewhere.

[Kasula11]

@matriv I just want to know whether my understanding is correct or not regarding implementation of to_char() function. For example if i am going to implement to_char function for converting time stamp to string than the arguments that are passed to to_char function are timestamp and pattern which are of Expression Type.

Using DATETIME_FORMAT(DateTimeFormat class) I am going to getting the Desired format for particular timestamp and return string version of it?

[cheng141]

I Just want to you

[z13z]

Hi, if it's possible I would like to start working on this issue.

[grgAditya]

Hi is someone working on this or I can take this up?

[devanandch]

Hi, can i work on this item please

[devanandch]

any update on my request

[matriv]

@devanandch Sorry for the delay, go ahead and please use the same approach as in #55454

[syedsouban]

Hi @devanandch let me know if you are working on it, otherwise I would like to work on it. Thanks!

[devanandch]

Hi @syedsouban i am working on it.

[devanandch]

@devanandch Sorry for the delay, go ahead and please use the same approach as in #55454

Thank you Matriv, I will make sure to get the PR submitted soon.

[SrihariShastry]

Hi, is anyone working on this or can I take this up?

[bpintea]

Hi. Thank you for your interest in contributing!
Inline with common open source practices, we would like to no longer block and attribute issues, but rather invite anyone with a concrete proposal to simply submit a PR. No one likes duplicating work, but please consider that chances of concurrent PRs are low - especially for longer standing issues - and quality will trump over submission order.

[philkra]

@mohammedtabish, please refer to one of the previous comments #54964 (comment)

[matriv]

Please try to use the pattern of a similar PR: #62701

[pspranjal444]

Hi @matriv. I am new to open source. Can you please provide more context on what exactly to do ? I have to add to_char() in DateTimeFormatProcessor.java file. Is that correct ?

[matriv]

@pspranjal444 The implementation is pretty straight forward, please look at my previous comment and follow the pattern for implementing another flavour of this function.

[LahiruSen]

Implement to_char according to the PostgreSQL spec: https://www.postgresql.org/docs/9.1/functions-formatting.html by translating to the java.time patterns used in DATETIME_FORMAT.
Follows: #54832

Hi @matriv , I would like to work on this issue.

[rakeshmissioncode]

I'd like to start contributing to this issue.
Any hints on which part of the code I should start with, for this issue?

[matriv]

@rakeshmissioncode

Hi. Thank you for your interest in contributing!
As you can see the feature has already been implemented: #66486

For the future and inline with common open source practices, we would like to no longer block and attribute issues, but rather invite anyone with a concrete proposal to simply submit a PR. No one likes duplicating work, but please consider that chances of concurrent PRs are low - especially for longer standing issues - and quality will trump over submission order.

[matriv]

Implemented with #66486