Monthly Archive for: ‘June, 2011’

  • shadowDate-Time Calculations: Part 2
    image
    shadow

    Date/Time Calculations: Part 2

    In Part 1 of this topic, we considered how input dates can be manipulated to dynamically generate whatever ranges a query needs. As promised, it’s time to look at more intriguing combinations. So, to start: A common requirement in many applications is to do calculations …

    Read More

  • shadowDate-Time Calculations: Part 1
    image
    shadow

    Date/Time Calculations: Part 1

    Knowing how to format dates for input and output is a good first step, but the real goal of any database system is to allow the user to query the data to answer business questions. Expecting all date range queries to have hard-coded values for …

    Read More

  • shadowOutput Date Formatting
    image
    shadow

    Output Date Formatting

    In this post, Data Education founder and trainer Adam Machanic continues his discussion on the CONVERT function. Here, he explains that the only difference is that the function is converting an instance from a date/time to a string rather than the other way around. The …

    Read More

  • shadowInput Date Formats
    image
    shadow

    Input Date Formats

    In this post, Data Education founder and trainer Adam Machanic discusses international standard date and time formats. Here, he explains the importance of not using ambiguous date formats. There is really only one rule to remember when working with SQL Server’s date/time types from a …

    Read More

  • shadowWorking with Temporal Data: Representing More Than Just Time
    image
    shadow

    Working with Temporal Data: Representing More Than Just Time

    It’s probably fair to assert that time is a central component of every possible database of any interest to anyone. Imagining a database that lacks a time component is tantamount to imagining life without time passing; it simply doesn’t make sense. Without a time axis, …

    Read More