It depends on the client. If the client is calling getDate() then it is the client that is converting that java.sql.Date value to a string.
If you are using sqlline as the client, it would be useful feature to be able to say !set dateformat ‘yyyy/MM/dd' If you (or the client) is calling the JDBC ResultSet.getString method then AvaticaResultSet ultimately calls DateTimeUtils.unixDateToString via DateAccessor.getString(). I suppose a JDBC driver preference could change the format string used. Julian > On Jul 22, 2016, at 2:19 AM, Roman Lozovyk <ptreng...@gmail.com> wrote: > > I mean how dates displayed in SQL. > > 2016-07-21 20:41 GMT+00:00 Julian Hyde <jh...@apache.org>: > >> Do you mean how RexLiteral appears in plans? Or how dates are displayed in >> SQL? >> >> Julian >> >> >>> On Jul 21, 2016, at 10:06 AM, Roman Lozovyk <ptreng...@gmail.com> wrote: >>> >>> Hi all, >>> >>> I'm working on drill issue and trying to change print format of date for >>> RexLiteral from yyyy-MM-dd to yyyy/MM/dd, but seems that this feature >>> aren't available now. Is there any way to configure this? >>> >>> Thanks >> >>
