Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, Date Manipulation Rss

   Items 1 to 20 of 68    Older >>
 

It's the end of the year

By Steve Jones 2015/12/31 | Category: date manipulation
Rating: (not yet rated) |  Discuss |   Briefcase | 1,569 reads

Job Schedules

By Steve Jones 2015/11/10 | Category: sql agent
Rating: (not yet rated) |  Discuss |   Briefcase | 1,494 reads

DY

By Steve Jones 2015/11/06 | Category: date manipulation
Rating: (not yet rated) |  Discuss |   Briefcase | 1,548 reads

The First Day

By Steve Jones 2015/01/01 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,271 reads

Get month days

Gets the number of days in a month  Read more...
By Igor Micev 2014/11/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,238 reads

Calculate gregorian easter sunday using a table valued function

Calculate gregorian easter sunday using a table valued function.  Read more...
By Robin Langell 2014/09/03 | Source: SQLServerCentral.com | Category: easter sunday
Rating: |  Discuss |   Briefcase | 647 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 | 15,257 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 | 39,546 reads

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 | 7,032 reads

Group Islands of Contiguous Dates (SQL Spackle)

Fill in another bit of your T-SQL knowledge by learning how to quickly group ranges of contiguous dates without RBAR.  Read more...
By Jeff Moden 2013/10/04 (first published: 2010/12/07) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 16,327 reads

Sorting Months By Number (SQL Spackle)

Fill in another bit of your T-SQL knowledge by learning how to sort a result set by the proper month order, but use the month name instead.  Read more...
By Jeff Moden 2013/08/02 (first published: 2010/11/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 18,110 reads

Date add with Different DataType

By Paresh Patel 2013/06/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,457 reads

DATETIME - 4

By bitbucket-25253 2013/03/18 | Category: datetime
Rating: (not yet rated) |  Discuss |   Briefcase | 2,050 reads

Precision required

By David Bridge 2013/03/14 | Category: rounding
Rating: (not yet rated) |  Discuss |   Briefcase | 1,861 reads

INNER JOIN

By Kapil Singh 2013/03/12 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,255 reads

Converting to datetime a char field with several possible date formats

Converting to datetime a char field having several possible date formats  Read more...
By Federico Iori 2013/02/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,589 reads

SQL Server 2012: Time Marches On

Greg Larsen explores the new SQL Server 2012 date and time functions and shows you how to exploit these functions in new application code.  Read more...
By Additional Articles 2013/02/13 | Category: date manipulation
Rating: (not yet rated)  Rate this |   Briefcase | 3,281 reads

Date Difference

By Siddharth Tandon 2013/02/04 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,266 reads

EOMONTH - 1

By bitbucket-25253 2013/01/21 | Category: emonth
Rating: (not yet rated) |  Discuss |   Briefcase | 2,310 reads

Finding New Years Eve

By Steve Jones 2013/01/01 | Category: humor
Rating: (not yet rated) |  Discuss |   Briefcase | 2,693 reads
   Items 1 to 20 of 68    Older >>
 
Tags
datetime (5)    
humor (2)    
sql spackle (2)    
tally table (2)    
aggregates (1)    
between (1)    
blogs (1)    
case (1)    
convert (1)    
cte (1)    
date (1)    
date conversion (1)    
date data types (1)    
dateadd (1)    
datediff (1)    
datepart (1)    
easter sunday (1)    
emonth (1)    
fall on friday (1)    
modulus (1)    
msdb (1)    
next 13th (1)    
nth occurance of day in a month/year (1)    
partitioned sets (1)    
recursion (1)    
rounding (1)    
row_number() (1)    
scripts (1)    
set dateformat (1)    
sql agent (1)    
sql server 2012 (1)    
sql server 7 (1)    
table valued function (1)    
user defined function (udf) (1)