Ah, that makes sense - at least your part of it. Why Oracle would create those two date fields as varchars and not dates doesn’t necessarily.
Thank you for explaining. Looks like I’ll just deal with it and try to remember not to report it again in the future. I would hate to start seeing all my dates in the format that they use in the varchars.
On Tue, Aug 30, 2016 at 2:37 PM, John Dorlon email@example.com wrote:
RE: Inconsistent date/time format in Session Browser
Reply by John Dorlon
I agree, it would be nice if they were consistent. These values come from the V$SQL view. Unfortunately, FIRST_LOAD_TIME and LAST_LOAD_TIME are VARCHAR2 columns, so Oracle is in control of the format. LAST_ACTIVE_TIME is a DATE column, so for that one, the format is controlled by your options in Toad.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.
Toad for Oracle - Beta Discussion Forum
Flag this post as spam/abuse.
Digital Products & Strategies, Cru | Data Sciences & Analytics