FriskyKitty

53
reputation
7

Finance professional. Learned early on that the real data is stored in databases. Stumbled on SQL by happy accident. ODBC connections to Microsoft Office came next.

That was the beginning of journey into the world of SQL programming (Microsoft T-SQL and Oracle).

I try to avoid questioning other people's approach. For example, questions about date and time formatting often elicit responses about the database itself, e.g.

"Why is the date stored as a string? If it were stored as a date you would not need to format the results. Fix the table, not the query!"

That comment, however true, however, ignores permissions and/or intractable business practices. A preferable solution would include the needed answer, e.g.

SELECT
     TO_DATE(TO_CHAR(SysDate))
    ,TO_CHAR(SysDate, 'MMDDYY')
FROM DUAL ;

along with suggested improvements to the database.

Anyway, happy to join the StackOverflow, Exchange, etc. team.