Post reply

Stairway to Data, Level 4: Temporal Data

  • March 26, 2019 at 1:37 pm

    #2030900

    Comments posted to this topic are about the item Stairway to Data, Level 4: Temporal Data

    Books in Celko Series for Morgan-Kaufmann Publishing
    Analytics and OLAP in SQL
    Data and Databases: Concepts in Practice
    Data, Measurements and Standards in SQL
    SQL for Smarties
    SQL Programming Style
    SQL Puzzles and Answers
    Thinking in Sets
    Trees and Hierarchies in SQL

  • July 8, 2020 at 3:48 pm

    #3768463

    In "Julianized Calendars" the image after your text "Here is an example from 2007" is the same as the image above it.  I wasn't quite getting the intent, as I would expect the numbering sequence to be:

    (starting with Monday, January 1st) 1,2,3,4,5,5,5,8,9,10,11,12,12,12,15,16...

    But, the second Monday isn't 7 "business days" after the first Monday, it's only 5, so the entire sequence would have to slide?

    (starting with Monday, January 1st) 1,2,3,4,5,5,5,6,7,8,9,10,10,10,11,12...

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply