Stairway to Data, Level 4: Temporal Data

  • Joe Celko

    SSCertifiable

    Points: 5638

    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

  • Dan Bragg

    Old Hand

    Points: 369

    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 2 (of 2 total)

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