THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » T-SQL » datetime » sql server   (RSS)
  • Standard Point-in-time and time-interval representations

    One requirement in any database implementation that I have ever worked on is that the notion of a point-in-time has to be represented in some way. The tool that I use on a regular basis, SQL Server, provides numerous datatypes that aid in the representation of a point-in-time and I’m sure that most people reading this will be au fait with them. ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 28, 2009
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement