SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Date Manipulation Rss

   Items 1 to 20 of 120    Older >>
 

Getting the Create Date

By Steve Jones 2018/01/16 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 744 reads

Bones of SQL – Grouping By User-Defined Calendar Periods

Although it is common to group by periods such as Week, Month, or Quarter, sometimes alternative periods are needed. This simple technique lets you split a year into periods with any number of days.  Read more...
By Bob Hovious 2017/12/08 (first published: 2016/09/26) | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 2,462 reads

Bones of SQL - The Calendar Table

This article introduces the concept of the Calendar table to SQL newcomers and illustrates use of a few columns they might not have imagined.  Read more...
By Bob Hovious 2017/11/24 (first published: 2016/09/08) | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 7,523 reads

Reporting by date - DateTrunc

A function to truncate datetimes to month, quarter, hour etc and their multiples for convenient grouping  Read more...
By Mike Tanner 2017/11/21 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 326 reads

Fun with Dates

By Steve Jones 2017/10/27 | Category: coalesce
Rating: (not yet rated) |  Discuss |   Briefcase | 1,138 reads

FORMATting dates

By Steve Jones 2017/10/24 | Category: format()
Rating: (not yet rated) |  Discuss |   Briefcase | 981 reads

The Current Date

By Steve Jones 2017/07/25 | Category: date manipulation
Rating: (not yet rated) |  Discuss |   Briefcase | 1,022 reads

Function to Round or Truncate DateTime

This Function is used to round to Second, Minute, Hour or Day or to Truncate to Second, Minute, Hour, Day, Month or Year and return Datetime Value  Read more...
By Shane Clarke 2017/05/31 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 535 reads

Count Year,Month,Day

This Syntax will help you to search how many period left your data/assets must be followed up or changed or disposed  Read more...
By Deny Christian 2017/01/25 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 552 reads

Change datetime

If you have any requirement to extract next 100 sequential date from a present date, you can use the below script. You can change the @datetimeformat value and the output will appear in the same format.  Read more...
By S M 2016/10/10 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 458 reads

Bones of SQL – Grouping By User-Defined Calendar Periods

Although it is common to group by periods such as Week, Month, or Quarter, sometimes alternative periods are needed. This simple technique lets you split a year into periods with any number of days.  Read more...
By Bob Hovious 2017/12/08 (first published: 2016/09/26) | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 2,462 reads

The Bones of SQL - The Holiday Table

This second part to a previous article on Calendar table generation shows how to create a holiday table containing both fixed-date and variable-date holidays.  Read more...
By Bob Hovious 2016/09/19 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 2,689 reads

Bones of SQL - The Calendar Table

This article introduces the concept of the Calendar table to SQL newcomers and illustrates use of a few columns they might not have imagined.  Read more...
By Bob Hovious 2017/11/24 (first published: 2016/09/08) | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 7,523 reads

Bones of SQL

Learn how to use a calendar table to make your reporting queries much simpler.  Read more...

Calendar Table Function

This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently  Read more...
By Chris Kutsch 2016/08/02 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 4,591 reads

A SQL Server Date Handling Issue

How do you think SQL Server will handle this scenario ?  Read more...
By David Ozono 2016/06/20 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 2,310 reads

A Scary Day

By Steve Jones 2016/05/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,846 reads

Calculate Age (in years)

An inline table valued function (iTVF) that can be used to calculate age in years.  Read more...
By Alan Burstein 2016/04/27 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 897 reads

Finding the quarter

By Steve Jones 2016/02/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,577 reads

Calendar Table Function

This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently  Read more...
By Chris Kutsch 2016/08/02 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 4,591 reads
   Items 1 to 20 of 120    Older >>
 
Tags
t-sql (71)    
datetime (8)    
calendar (3)    
date (3)    
humor (3)    
sql spackle (3)    
blogs (2)    
cte (2)    
date conversion (2)    
datediff (2)    
sql server 2008 (2)    
tally table (2)    
user defined function (udf) (2)    
age (1)    
aggregates (1)    
analysis services (ssas) (1)    
between (1)    
case (1)    
coalesce (1)    
convert (1)    
datatype (1)    
datatypes (1)    
date data types (1)    
dateadd (1)    
datepart (1)    
datetimeoffset (1)    
dimensions (1)    
easter sunday (1)    
emonth (1)    
fall on friday (1)    
format() (1)    
formatting (1)    
group by (1)    
holiday (1)    
holidays (1)    
inline table valued function (itvf) (1)    
language conversion (1)    
modulus (1)    
months (1)    
msdb (1)    
next 13th (1)    
nth occurance of day in a month/year (1)    
partitioned sets (1)    
powershell (1)    
proclarity (1)    
recursion (1)    
round() (1)    
row_number() (1)    
scripts (1)    
set dateformat (1)    
set-based (1)    
sql agent (1)    
sql server 2012 (1)    
sql server 7 (1)    
stored procedures (1)    
table valued function (tvf) (1)    
tips & tricks (1)    
week days (1)