Category: Code
This area of the site is dedicated to code snippets for quick and easy reference
Format Date Function
Source: http://www.vbforums.com/showthread.php?545861-SQL-Server-Date-Format-Function-in-English-and-French
Monday Date Calculation
Source: http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/
Get Number Of Business Days Between Two Dates
Source: http://www.sqlusa.com/bestpractices/datetimeconversion/
SQL DateTime Conversion
Sources: http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/ http://www.sqlusa.com/bestpractices/datetimeconversion/
Time ASP Execution
Source: http://classicasp.aspfaq.com/general/how-do-i-time-my-asp-code.html
Host File Update
Proxy Server host block list is now available at http://goo.gl/jXiOLp, make sure you do not use this in Windows host file. It’s a good idea to do this script in a directory that is specific to your host file project Make sure you chmod the shell script Mac OS X…
Delete Ektron User
In order to force a deletion from the Ektron user list you must follow the below path. DISCLAIMER: This will remove all content that was ever created/touched by the user.
LDAP Dates Converted
Dates that look like 127524839567199000 (pwdLastSet, accountExpires, lastLogonTimestamp, etc.) Example: 130186556607343750 converts to 40921.80861 40921.80861 in Excel with cell formatting of Date/Time will show as January 13th, 2012 7:24 PM Dates that look like 20050210223453.0Z (whenChanged) Example: 20080523192311.0Z in Excel with cell formatting of Date/Time will show as 7/18/2013 9:14…