• About
  • All Posts
  • The Podcast!
  • 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
  • The Podcast!

Tag: dates

February 2, 2022 Uncategorized

Awesome DATE / TIMESTAMP enhancement in Autonomous Database

Date management is a commonly encountered issue when customers want to move their database to a cloud environment. If you

Continue reading

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

October 21, 2016 Uncategorized

Truncating a timestamp to the second

We had an interesting AskTom question recently, about why certain TRUNC commands would generate an error when applied to a

Continue reading

September 22, 2016 Uncategorized

The simple fix to date queries

We had question in the OpenWorld panel about why queries on date columns are “always slow”.  Well….they aren’t but here’s

Continue reading

May 28, 2016 Uncategorized

Datatypes for DATES

Richard Foote has written a post about not using the DATE datatype for storing dates. So I’ve come up with

Continue reading

May 13, 2016 Uncategorized

Those pesky dates as strings

You might be thinking “Nothing is more frustrating that encountering a string column that is full of dates”. But there

Continue reading

March 1, 2016 Uncategorized

Is a year a leap year ?

This post seems timely given that yesterday was Feb 29. In almost every case I can think of, you should

Continue reading

January 27, 2016 Uncategorized

Automatic date formats

Notice in all of the examples below that the date string does not match the format mask. When a date

Continue reading

April 20, 2015 Uncategorized

NUMBER data type…what harm can it do ?

There’s a somewhat sour discussion going on based attached to the video at https://www.youtube.com/watch?v=jZW-uLb52xk Whether you agree or disagree with

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.

Tweets by connor_mc_d

    Top Posts & Pages

    • The new forums
    • How to do a GRANT on an entire schema
    • The simple fix to date queries
    • How to TREAT data in a CLOB as JSON
    • Generating INSERT scripts that run fast!
    • Connection shortcuts with a wallet
    • Digging deeper into SQL under APEX
    • Why you keep getting "ORA-01653: unable to extend table"
    • How to generate random unique values
    • No more stale statistics in 19c
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 848 other followers
      • Already have a WordPress.com account? Log in now.
      • Learning is not a spectator sport
      • Customize
      • Follow Following
      • Sign up
      • Log in
      • Report this content
      • View site in Reader
      • Manage subscriptions
      • Collapse this bar