THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » t-sql tuesday » datetime   (RSS)
  • Unambiguous date formats : T-SQL Tuesday #001

    One of the most commonly used data types in SQL Server is [datetime] which unfortunately has some vagaries around how values get casted. A typical method for defining a [datetime] literal is to write it as a character string and then cast it appropriately. The cast syntax looks something like this: DECLARE @dt ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 8, 2009
  • T-SQL Tuesday #001: My Datetime FAQ

    I am rising to Adam's challenge for his very first T-SQL Tuesday, and blogging about datetime issues. Since I just finished a 9-hour teaching day in Stockholm, and I'm incredibly jetlagged, I decided to keep this simple. I'm very much looking forward to what everyone else is going to say! For as long as I've been providing TSQL support, starting ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on December 8, 2009
  • T-SQL Tuesday #001: Yesterday it worked, today it's not working...

    But did it actually work yesterday? If the day is Friday, Noverber 13th, or the 13th day of any other month, and your query blows up for the first time, one place to search for is character strings converted to datetime values. The following script illustrates the ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on December 8, 2009
Privacy Statement