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

Scripts by Shane Clarke

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

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 | 466 reads

Function to convert UserAccountControl number to details text

Function that converts AD UserAccountControl number to details text  Read more...
By Shane Clarke 2015/07/27 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 1,131 reads

Function to calculate and return age in text to closest minute between

Calculates and returns age in text to closest minute between 2 datetimes, eg: 2 Years, 4 Months, 12 Days, 4 Hours, 17 Minutes  Read more...
By Shane Clarke 2016/08/12 | Source: SQLServerCentral.com | Category: age
Rating: |  Discuss |   Briefcase | 1,703 reads
   Items 1 to 3 of 3