The Weird and The Wonderful

SEC_TO_TIME( sum( time_to_sec(endtime)-time_to_sec(starttime))) as Duration

Michael K Gray wrote:

Another good reason to buy SQL Server, or ORACLE, etc.

RCoate wrote:

// Format month
if (month.Length == 1){ month = "0" + month; }
 
// Format day
if (day.Length == 1){ day = "0" + day; }

// Format month
var sbMonth = new StringBuilder();
if (month.Length == 1)
{
    sbMonth.Append("0");
}
sbMonth.Append(month); 

// Format month
var sbMonth = new StringBuilder();
sbMonth.Append(month);
if (month.Length == 1)
{
    sbMonth.Insert(0, "0");
}

var sbMonth = new StringBuilder();
try
{
  int x = 1 / month.Length -1;
  sbMonth = AppendMonth(sbMonth);
}
catch
{
  sbMonth = AppendMonth(sbMonth, "0" + month);
}

private StringBuilder AppendMonth(StringBuilder sb, string s)
{
    string x = sb.Append(s).ToString();
    StringBuilder y = new StringBuilder();
    return y.Append(x);
}

string DocumentName = string.Format("Application - [{0}] - {1:yyyyMMdd}", Person.RegistrationNo, DateTime.Now);

string Daternator()
{
    DateTime dt = DateTime.Now;

    string result = ""; // Failure to use String.Empty - Check
    
    // Homemade string concat - Check
    for (int i = 0; i < 3; i++)
    {
        if (i == 0)
            result += dt.Year.ToString() + ", ";
        else if (i == 1)
            result += dt.Month.ToString() + ", ";
        else if (i == 2)
            result += dt.Day.ToString() + ", "; // Unnecessary code - Check 
    }

    // More unnecessary code to fix previous unnecessary code - Check
    result = result.Remove(result.LastIndexOf(" "), 1);
    result = result.Remove(result.LastIndexOf(","), 1);

    // My lord, he wouldn't...
    Start:

    // And what's this? Regex? Fancy!
    MatchCollection mc = Regex.Matches(result, @"\b(\d)\b");

    // I like where this is headed...
    foreach (Match m in mc)
    {
        if (m.Success)
        {
            result = result.Insert(m.Index, "0");
            goto Start; // Oh lord, he did, a goto loop - Check
        }
    }

    // Sweet sciency magic we have a result!!
    return string.Format("Application - [{0}] - " + result, this.Person.RegistrationNo.ToString());
}