On Wed, 22 Feb 2023 at 13:38, Kirk Wolak <wol...@gmail.com> wrote: > > I already requested ONLY the HH24 format. 8 characters of output. no > options. It's a waste of time. > After all these years, sqlplus still has only one setting (show it, or not). > I am asking the same here. > And I will gladly defend not changing it! Ever!
Yeah, well, it's kind of beside the point that you're satisfied with this one format. We tend to think about what all users would expect and what a complete feature would look like. I actually tend to think this would be a nice feature. It's telling that log files and other tracing tools tend to produce exactly this type of output with every line prefixed with either a relative or absolute timestamp. I'm not sure if the *prompt* is a sensible place for it though. The place it seems like it would be most useful is reading the output of script executions where there would be no prompts. Perhaps it's the command tags and \echo statements that should be timestamped. And I think experience shows that there are three reasonable formats for dates, the default LC_TIME format, ISO8601, and a relative "seconds (with milliseconds) since starting". I think having a feature that doesn't support those three would feel incomplete and eventually need to be finished. -- greg