using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace CalculateTimeDifference{class Program{static void Main(string[] args){string result;// start time of this programDateTime dStart = DateTime.Now;result = string.Format("Start: Year:{0}, Month:{1}, Day:{2}, Hour:{3}, Minute:{4}, Second:{5}, Millisecond:{6}, In Ticks:{7}", dStart.Year, dStart.Month, dStart.Day, dStart.Hour, dStart.Minute, dStart.Second,dStart.Millisecond, dStart.Ticks);Console.WriteLine(result);Console.ReadLine();// wait until you press enter// end time of this programDateTime dEnd = DateTime.Now;result = string.Format("End : Year:{0}, Month:{1}, Day:{2}, Hour:{3}, Minute:{4}, Second:{5}, Millisecond:{6}, In Ticks:{7}", dStart.Year, dStart.Month, dEnd.Day, dEnd.Hour, dEnd.Minute, dEnd.Second, dEnd.Millisecond, dEnd.Ticks);Console.WriteLine(result);// compute running time or time difference of this programTimeSpan dDifference = dEnd.Subtract((dStart));result = string.Format("RunningTime: {0} days, {1} hours, {2} minutes, {3} seconds, {4} milliseconds, In Ticks:{5}", dDifference.Days, dDifference.Hours, dDifference.Minutes, dDifference.Seconds, dDifference.Milliseconds, dDifference.Ticks);Console.WriteLine(result);// wait to preserve the result until you press enterConsole.ReadLine();}}}
I wanted to setup MySQL to use utf-8 on the MAMP installation on my Mac. I tried the instructions from this article: http://cameronyule.com/2008/07/configuring-mysql-to-use-utf-8/ However, I kept getting error messages that are similar to this one [ERROR] /Applications/MAMP/Library/bin/mysqld: unknown variable 'default-collation=utf8_general_ci' I did some search and realized that several variables are deprecated. Reference: http://dev.mysql.com/doc/refman/5.1/en/server-options.html Therefore, I added the following lines into /Applications/MAMP/conf/my.cnf [mysql] character-set-server=utf8 [client] character-set-server=utf8 [mysqld] character-set-server=utf8 collation-server=utf8_general_ci init-connect='SET NAMES utf8' I restarted the server and mysql run successfully with relevant variables being set correctly. In the "Variables" tab under phpMyAdmin interface (ex. http://localhost:8888/MAMP/?language=English) character set c
Comments