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

Scripts with tag DateFirst Rss

Search for any content tagged datefirst

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 3 of 3   
 

Work time calculation

One way to calculate how many minutes a person has worked considering holidays and shifts, being given starting and ending date / time  Read more...
By Alessandro Mortola 2016/09/29 | Source: SQLServerCentral.com | Category: datefirst
Rating: (not yet rated) |  Discuss |   Briefcase | 359 reads

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 | 200 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 | 476 reads
   Items 1 to 3 of 3