I don’t think there’s a standard, and we wouldn’t be solving the problem if we create our own “standard”. (See https://xkcd.com/927/ <https://xkcd.com/927/>.) So it’s better to implement everyone else’s “standard” and let our users choose.
It would be a great start if someone were to contribute an implementation of Oracle’s TO_CHAR function that works for number, date, time, timestamp, interval. It’s one of a long list of functions in https://issues.apache.org/jira/browse/CALCITE-759 <https://issues.apache.org/jira/browse/CALCITE-759>. (Not to play favorites - we’d be happy to also accept implementations of every other database’s TO_CHAR function, or equivalent.) Julian > On Feb 20, 2020, at 3:02 AM, Soma Mondal <[email protected]> wrote: > > Hi, > > > We are seeing that in many dialects, there is support for formatting dates, > times and timestamps (please see THIS > <https://docs.google.com/spreadsheets/d/19x0hK3LcHxhdcx-Q7j1i8jZOoxRoUJjUTp3VxeWt4Ak/edit?usp=sharing> > link for information about SqlServer, MySql, Oracle, Teradata). > > > In the current standard operator table, we don't see any operator that does > such a thing. We were thinking that we should add a new standard operator > which follows the formatting standard followed by SimpleDateFormat.java > > > Can you please share your inputs regarding this? Should we go ahead and do > so or do you have other thoughts regarding this? > > > *Regards,* > *Soma Mondal*
