Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Date Manipulation Rss

Search for any content tagged date manipulation

<< Newer    Items 21 to 40 of 40   
 

How to Compare Rows within Partitioned Sets to Find Overlapping Dates

How to Compare Rows within Partitioned Sets to Find Overlapping, Contiguous, or Gap dates  Read more...
By Kevin Wu 2013/12/25 (first published: 2010/10/11) | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 6,929 reads

Calendar Tables II - The Anchor

Show the results for a date even if there is no data.  Read more...
By Todd Fifield 2014/02/21 (first published: 2010/08/16) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 14,871 reads

Creating Holidays and Special Dates

A way to save holiday records that can be created as needed into a search-able calendar table.  Read more...
By Terry Steadman 2010/08/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,018 reads

Tally Table Uses - Part I

In the first part of a series on Tally Tables, Stefan Krzywick shows how a Tally Table has helped out with fiscal year calculations.  Read more...
By Stefan Krzywicki 2010/08/02 | Source: SQLServerCentral.com | Category: tally table
Rating: |  Discuss |   Briefcase | 14,364 reads

Calendar Tables

Learn how to avoid complex date calculations and increase performance using calendar tables in this article from Todd Fifield.  Read more...
By Todd Fifield 2014/02/14 (first published: 2010/07/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 38,249 reads

Using dates, and times in SQL Server: a workbench approach

In this workbench, Robyn Page provides a gentle introduction to the use of dates in SQL Server. In this new version of her article, it is brought up to date with the newer Datetime features in SQL Server 2005 and 2008.   Read more...
By Additional Articles 2010/05/27 | Source: SimpleTalk | Category: date manipulation
Rating:  Rate this |   Briefcase | 4,966 reads

Date Manipulation with DATEADD/DATEDIFF

Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phelabaum.  Read more...
By Seth Phelabaum 2010/04/07 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 17,303 reads

Tally Table - Character Date Validation

Tally (or numbers) tables are one of my favorite query writing tools.  Such a simple premise that can be applied...  Read more...
By Seth Phelabaum 2009/12/17 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,260 reads

Formatted date in SQL Server 2008

Learn how to get most of the formats required by different countries and applications, using one common date function.  Read more...
By Additional Articles 2009/06/02 | Source: Database Journal | Category: date manipulation
Rating:  Rate this |   Briefcase | 3,435 reads

SQL Server user defined function to convert MSDB integer value to time value

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...
By Additional Articles 2009/05/20 | Source: MSSQLTips.com | Category: msdb
Rating: (not yet rated)  Rate this |   Briefcase | 2,006 reads

To Date or Not To Date….

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...
By Sam Bendayan 2009/05/18 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,330 reads

Comparison of Dates in SQL

This article discusses a common mistake while making date comparisons in T-SQL and its resolution. From new author Manish Sinha.  Read more...
By Manish Sinha 2009/04/28 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 15,382 reads

SQL Server UDF to convert integer date to datetime format

This short tip shows how you can convert an integer date, such as those stored in msdb to a real datetime value.  Read more...
By Additional Articles 2009/04/03 | Source: MSSQLTips.com | Category: date manipulation
Rating:  Rate this |   Briefcase | 2,968 reads

Date Dimensions Part 2

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...
Rating: |  Discuss |   Briefcase | 11,382 reads

Useful Dates: The Many Uses of Date Tables

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...
By Brandon Galderisi 2008/12/17 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 11,610 reads

Compare Dates in an iterative manner for a particular set of records

Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000  Read more...
By Divya Agrawal 2008/11/12 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,700 reads

Compare Dates

The following article shows how to compare dates in an iterative manner for a particular set of records in a single query  Read more...
By Additional Articles 2008/10/27 | Source: SQL Server Performance | Category: t-sql
Rating:  Rate this |   Briefcase | 4,878 reads

Two methods for converting T-SQL date/time values

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...
By Additional Articles 2008/09/01 | Source: SearchSQLServer | Category: t-sql
Rating:  Rate this |   Briefcase | 7,112 reads

Basics for working with DATETIME and SMALLDATETIME

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...
By Additional Articles 2008/08/15 | Source: SearchSQLServer | Category: date manipulation
Rating:  Rate this |   Briefcase | 5,712 reads

Missing Date Ranges- the Sequel

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...
By Additional Articles 2008/07/03 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 2,786 reads
<< Newer    Items 21 to 40 of 40