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 <[email protected]>，写道： > 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*
