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

Content with tags T-SQL, Datetime Manipulation Rss

   Items 1 to 12 of 12   
 

DateTime data types

By Sasidhar Pulivarthi 2013/04/11 | Category: datetime manipulation
Rating: (not yet rated) |  Discuss |   Briefcase | 1,799 reads

Deterministic

By Joe Barth 2013/03/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,043 reads

New Year's Math

By Steve Knox 2013/01/03 | Category: datetime functions
Rating: (not yet rated) |  Discuss |   Briefcase | 2,256 reads

Payment due date function

Calculates the nth due date for any given date, while accounting for weekends.  Read more...
Rating: |  Discuss |   Briefcase | 2,552 reads

DateTime Puzzle

By Sunil Chandurkar 2012/05/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,492 reads

Different Date Formats

You Can Find Some Date Functions and extracting the different Date Formats using the Convert and Cast  Read more...
By Vinuraj R 2012/03/23 | Source: SQLServerCentral.com | Category: datetime manipulation
Rating: |  Discuss |   Briefcase | 3,515 reads

DateTime Trick

By Volkan Kuyucuoglu 2009/10/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,451 reads

Nth occurrence of a weekday in a month and year

To find date at nth occurrence of a weekday in a month and year  Read more...
Rating: |  Discuss |   Briefcase | 717 reads

SQL Server Function to Determine a Leap Year

I need to write a function to determine if particular year is a leap year (i.e. February contains 29 days rather than 28 days). I know that there are various rules for calculating leap years. Is there an easy way to figure this out? Can you provide an example or two to validate various years?  Read more...
By Additional Articles 2008/07/14 | Source: MSSQLTips.com | Category: datetime manipulation
Rating:  Rate this |   Briefcase | 5,268 reads

Different Date Formats

You Can Find Some Date Functions and extracting the different Date Formats using the Convert and Cast  Read more...
By Vinuraj R 2012/03/23 | Source: SQLServerCentral.com | Category: datetime manipulation
Rating: |  Discuss |   Briefcase | 3,515 reads

Payment due date function

Calculates the nth due date for any given date, while accounting for weekends.  Read more...
Rating: |  Discuss |   Briefcase | 2,552 reads

Working with Time Spans and Durations in SQL Server

What is the best way to return the "duration" of an event in SQL, given the start and end datetime values? How can we add up these durations to return grand totals? What data types should be used to return this data to our clients? How do we handle overflows, such as when hours go over 23 or minutes total up to over 59? Are there any T-SQL functions or other techniques that are useful in these scenarios?   Read more...
By Additional Articles 2007/10/24 | Source: SQLTeam.com | Category: t-sql
Rating:  Rate this |   Briefcase | 3,788 reads
   Items 1 to 12 of 12