Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag DateFirst Rss

   Items 1 to 3 of 3   
 

Monday whatever the circumstances

The script returns Monday 00:00 regardless of the @@DATEFIRST  Read more...
By Peter Shilovich 2016/02/12 | Source: SQLServerCentral.com | Category: datefirst
Rating: (not yet rated) |  Discuss |   Briefcase | 174 reads

Week Starts On Saturday?

A function that emulates SET DATEFIRST 6 within a function for finding relevant date information.  Read more...
By Terry Steadman 2012/02/29 | Source: SQLServerCentral.com | Category: saturday
Rating: |  Discuss |   Briefcase | 475 reads

Finding the Correct Weekday Regardless of DateFirst

In this article, learn how to get the correct weekday regardless of the DateFirst setting on your server.  Read more...
By Divya Agrawal 2010/02/19 | Source: SQLServerCentral.com | Category: datefirst
Rating: |  Discuss |   Briefcase | 6,738 reads
   Items 1 to 3 of 3   
 
Tags
@@datefirst (2)    
date's (1)    
datetime functions (1)    
monday (1)    
saturday (1)    
weekday (1)