Contact Us

Use the form on the right to contact us.

You can edit the text in this area, and change where the contact form on the right submits to, by entering edit mode using the modes on the bottom right. 

Oak Ridge, TN, 37830
United States


DateDiff and its Parts

Wade Cantley

Because it helps to know the difference.

DATEDIFF ( datepart , startdate , enddate )

/*   datepart
year       yy, yyyy
quarter    qq, q
month      mm, m
dayofyear  dy, y
day        dd, d
week       wk, ww
hour       hh
minute     mi, n
second     ss, s
millisecond ms
microsecond mcs
nanosecond  ns

SQL Pie Cocktail

  • 1-1/2 oz. vodka or tequila
  • 1 oz. Hiram Walker Butterscotch Schnapps
  • 1-1/2 oz. apple cider
  • 1 tsp. fresh lemon juice
  • Apple slice for garnish