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

Content with tag Date Manipulation Rss

   Items 1 to 20 of 79    Next 20 >>
 

DATETIME - 4

By bitbucket 2013/03/18 | Category: datetime
Rating: (not yet rated) |  Discuss |   Briefcase | 1,750 reads

Precision required

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

INNER JOIN

By Kapil Singh 2013/03/12 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,009 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,243 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 | 2,921 reads

Date Difference

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

EOMONTH - 1

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

Finding New Years Eve

By Steve Jones 2013/01/01 | Category: humor
Rating: (not yet rated) |  Discuss |   Briefcase | 2,201 reads

Datetime Default

By malls reddy 2012/11/27 | Category: date manipulation
Rating: (not yet rated) |  Discuss |   Briefcase | 2,037 reads

Nanoseconds

By Tom Thomson 2012/11/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,176 reads

SQL Server Function to return a range of dates

A quick solution is a table function that will create a date range based on the parameters given. Then, you can just join to the results.  Read more...
By Additional Articles 2012/11/02 | Source: MSSQLTips.com | Category: date manipulation
Rating:  Rate this |   Briefcase | 4,068 reads

Days Difference Between 2 Dates

By Dwain Camps 2012/10/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,488 reads

ISDATE

By Lokesh Vij 2012/08/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,465 reads

DATEADD function

By Lokesh Vij 2012/08/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,725 reads

Literal Dates

By Mark Cowne 2012/07/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,539 reads

DateFormat

By Viral Shah 2012/07/03 | Category: set dateformat
Rating: (not yet rated) |  Discuss |   Briefcase | 2,627 reads

Date Conversions

By Lynn Pettis 2012/06/06 | Category: date conversion
Rating: (not yet rated) |  Discuss |   Briefcase | 2,829 reads

DateTime Functions

By Steve Jones 2012/04/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,610 reads

Dealing with custom date formats in T-SQL

Should I be formatting dates on the database side? What tools can I use in SQL Server to format and parse dates? This article helps you decide which one best suits your needs.  Read more...
By Gianluca Sartori 2012/03/23 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,622 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 2012/02/24 (first published: 2010/07/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 24,458 reads
   Items 1 to 20 of 79    Next 20 >>
 
Tags
t-sql (55)    
datetime (7)    
sql spackle (3)    
blogs (2)    
datediff (2)    
humor (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)    
cte (1)    
data types (1)    
datatype (1)    
date (1)    
date conversion (1)    
date data types (1)    
dateadd (1)    
datetimeoffset (1)    
dimensions (1)    
emonth (1)    
fall on friday (1)    
formatting (1)    
modulus (1)    
msdb (1)    
next 13th (1)    
nth occurance of day in a month/year (1)    
partitioned sets (1)    
proclarity (1)    
recursion (1)    
rounding (1)    
row_number() (1)    
scripts (1)    
set dateformat (1)    
sql server 2012 (1)    
sql server 7 (1)    
stored procedures (1)    
week days (1)