All Posts Tagged Tag: ‘output date format’

  • 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