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

Scripts with tag Date Manipulation Rss

Search for any content tagged date manipulation

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 20 of 23    Older >>
 

Convert Months,Days,ShortMonths to different Languages

Convert Months,Days,ShortMonths to Different Langauges with out sql server set language function can be used in views tables and stored procedures also includes proper case conversion  Read more...
By William McLaughlin 2014/02/03 | Source: SQLServerCentral.com | Category: dates
Rating: (not yet rated) |  Discuss |   Briefcase | 865 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,477 reads

UDF_GET_NEXT_WEEKDAY

A simple way of getting the next weekday's dates...  Read more...
By Praveen Kumar Peddi 2012/01/30 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 840 reads

Get next 1st thursday

Function to get the 1st thursday from the given day.  Read more...
By Harsha Majety 2012/01/20 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 966 reads

Getting Age in Text or Date Difference in text format

This function returns the difference between the date in text format   Read more...
By Anand Uchagawkar 2011/09/01 | Source: SQLServerCentral.com | Category: age
Rating: |  Discuss |   Briefcase | 967 reads

Holiday List

A table UDF to return a list of holidays for a given year.  Read more...
By Joe Booth 2011/06/22 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 1,594 reads

Find Last Day of the Month

Find the last day (or number of days in a month) in one statement without having to use IFs or BUTs.  Read more...
By Mariana Maas 2011/05/10 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 2,328 reads

Method to get the month name of a given date

Easy way to get the month name of a date  Read more...
By Subbu Ram 2011/05/06 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 1,490 reads

Function to get number of days in month

Function to get number of days in month  Read more...
By Harsha Majety 2011/04/27 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 2,568 reads

Previous Business Day

This SQL Server UDF returns the previous business day.  Read more...
By Arsen Serobian 2010/11/22 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 1,213 reads

UDF_GetGMTOffset

Calculates the offset between the UTC time and the SQL Server's local time.  Read more...
By Alex M 2010/11/26 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 549 reads

DateCeiling Function

Rounds dates up to the nearest datepart.  Read more...
By Gordon Klundt 2014/02/19 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 1,796 reads

DateFloor Function

Rounds dates down to the nearest datepart.  Read more...
By Gordon Klundt 2010/11/17 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,126 reads

A Flexible Day Of Week Function

A Flexible Day Of Week Function where a criteria can be passed as an integer to a stored procedure.  Read more...
By Todd Young 2010/10/13 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 1,307 reads

Pass in Year and Quarter and get the fiscal start and end dates

Pass Year and Quarter and get the Fiscal StartDate and Endate. Example: pass 2099-Q1 will yield the following results 2009-10-01 2009-12-31  Read more...
By Sriman Bapatla 2010/09/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 981 reads

Slow SP with date parameters solved.

when you use datetime parameters in SPs in the where clause the SP becomes very slow  Read more...
Rating: |  Discuss |   Briefcase | 2,790 reads

datetime precision

Accuracy and precision go hand-in-hand. This script helps trim date values to whatever size is stored in a table's column.  Read more...
By William Talada 2010/01/20 | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 1,085 reads

t-sql first last day date of the month

Returns the First or last day date of the month for a given date.  Read more...
By Bernabe Diaz 2009/12/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,721 reads

What were the dates of all the Fridays in this quarter?

This script displays list of all dates of all Fridays of this quarter.  Read more...
By Ashka Modi 2009/08/25 | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 1,026 reads

When will the next 13th fall on a Friday?

This example demonstrates how to use small part of complicated query structure.  Read more...
By Ashka Modi 2009/08/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 636 reads
   Items 1 to 20 of 23    Older >>