Re: Date and time formats in the standard operator table

Maybe the format for CAST in SQL 2016 [1] is what you need, it’s not implemented yet. [1] https://issues.apache.org/jira/browse/CALCITE-2980 Best, Danny Chan 在 2020年2月20日 +0800 PM7:02，Soma Mondal ，写道： > Hi, > > > We are seeing that in many dialects, there is support for formatting dates, > times

Re: Date and time formats in the standard operator table

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/ .) 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

Date and time formats in the standard operator table

Hi, We are seeing that in many dialects, there is support for formatting dates, times and timestamps (please see THIS link for information about SqlServer, MySql, Oracle, Teradata). In the cur