• About
  • All Posts
  • Playlists
  • Golden Oldies
Skip to content

Learning is not a spectator sport

  • 30 second guide to India
  • About
  • Archives
  • Golden Oldies
    • First match
    • Smart DBA
  • Playlists

Tag: to_date

February 8, 2021 Uncategorized

Counting business days between 2 dates

One of the most commonly hit questions on AskTom is how to count the number of work days (Mon =>

Continue reading

September 11, 2020 Uncategorized

Age calculations – Just how old ARE you?

Any database application that stores information about people will very likely store a person’s date of birth as part of

Continue reading

July 8, 2020 Uncategorized

Why relying on default DATE formats is a bug

Today’s quick but important message is…don’t be lazy! Look….I get it If given the choice of typing: ’01-JUL-20′ or typing

Continue reading

Over 500 posts …

Let’s connect

  • View connor_mc_d’s profile on Twitter
  • View connor_mc_d’s profile on Instagram
  • View connor-mcdonald-australia’s profile on LinkedIn
  • View UCVN7PnJnuKQ65QLmWjFvhiw’s profile on YouTube

Hi I'm Connor McDonald. I love playing with and exploring the Oracle database. But most of all I like seeing people succeed with the technology.
 
Subscribe for new posts by email.

Top Posts & Pages

  • Blockchain tables are here in 19c!
  • Archives
  • How to do a GRANT on an entire schema
  • No more stale statistics in 19c
  • My APEX was fine and then it wasn't
  • Pluggable database and restricted sessions
  • APEX 20.2 comes to town (well, to my PC)
  • Extended VARCHAR2 and the hidden LOB
  • Complex materialized views and fast refresh
  • Why you keep getting "ORA-01653: unable to extend table"
Blog at WordPress.com.