Tally (or numbers) tables are one of my favorite query writing tools.  Such a simple premise that can be applied...  Read more...

Learn how to get most of the formats required by different countries and applications, using one common date function.  Read more...

In a recent tip I outlined a process for converting a date, stored as an integer into a datetime data type. Date and time information for run history of SQL Server Agent jobs is stored within the msdb..sysjobshistory table as an integer data type, not as a datetime as one would expect. As promised, this tip picks up where we left off. On converting the integer-typed run_time into a format that is more user friendly for presentation purposes.  Read more...

OK….so I’m in the middle of a very interesting Effective Dating project…basically we’re dealing with some tables that only store current data, but there is a need for future-dated data as well. Because the base table can’t hold that data...  Read more...

This article discusses a common mistake while making date comparisons in T-SQL and its resolution. From new author Manish Sinha.  Read more...

This short tip shows how you can convert an integer date, such as those stored in msdb to a real datetime value.  Read more...

Continuing with his discussion of how to implement a date dimension in SQL Server Analysis services, expert warehousing expert Vincent Rainardi discusses how to use this dimension as a reference dimension as well as other advanced topics.  Read more...

Brandon Galderisi brings us a new article that looks at how a table of dates can be useful in a SQL Server application.  Read more...

Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000  Read more...

The following article shows how to compare dates in an iterative manner for a particular set of records in a single query  Read more...

Learn two built-in functions for SQL Server data conversion from T-SQL date/time values to character types. These methods include SQL Server CAST and CONVERT.  Read more...

Learn how data is stored within DATETIME and SMALLDATETIME and get an overview of the TIMESTAMP data type -- as it's often confused with these two primary date/time data types.  Read more...

Alex Kozak returns with another Date puzzle. A question from a Simple-Talk reader gives Alex the inspiration to see if is possible to list unused date ranges in one Select statement.  Read more...