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

Content with tag Date Manipulation Rss

   Items 1 to 20 of 114    Older >>
 

The Current Date

By Steve Jones 2017/07/25 | Category: date manipulation
Rating: (not yet rated) |  Discuss |   Briefcase | 990 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 | 472 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 | 534 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 | 451 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 2016/09/26 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 1,474 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,532 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 2016/09/08 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 5,631 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,572 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,306 reads

A Scary Day

By Steve Jones 2016/05/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,830 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 | 880 reads

Finding the quarter

By Steve Jones 2016/02/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,574 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,572 reads

It's the end of the year

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

Job Schedules

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

DY

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

How to Get SQL Server Dates and Times Horribly Wrong

One of the times that you need things to go right is when you are doing analysis and reporting. This is generally based on time and date. A sure-fire way of getting managers upset is to get the figures horribly wrong by messing up the way that you handle datetime values in SQL Server. In the interests of peace, harmony and a long career in BI, Robert Sheldon outlines some of the worst mistakes you can make when using SQL Server dates.  Read more...
By Additional Articles 2015/06/08 | Source: SimpleTalk | Category: date manipulation
Rating:  Rate this |   Briefcase | 6,925 reads

Converting and Using Text Dates as SQL Server Dates

This tip describes some T-SQL techniques for converting a mmddyyyy string to a SQL Server date, handling rows with missing date strings, and comparing converted date strings.  Read more...
By Additional Articles 2015/05/28 | Source: MSSQLTips.com | Category: date manipulation
Rating: (not yet rated)  Rate this |   Briefcase | 7,558 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,572 reads
   Items 1 to 20 of 114    Older >>
 
Tags
t-sql (69)    
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)    
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)    
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)    
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)