The Weird and The Wonderful

public class DateTimeExtended
{
    protected static readonly Logger Log = NLog.LogManager.GetCurrentClassLogger();

    public enum Days { Sun=0, Mon, Tue, Wed, Thu, Fri, Sat };

    public static string[] FerialDays = {"0101",
                                         "0501",
                                         "0508",
                                         "0714",
                                         "0815",
                                         "1101",
                                         "1111",
                                         "1225",
                                        };

    public static DateTime GetDate()
    {
        return DateTime.Now;
    }

    public static string GetDate(string format)
    {
        try
        {
            if(String.IsNullOrEmpty(format))
                return GetDate().ToString();
            else
                return GetDate().ToString(format);
        }
        catch
        {
            return DateTime.Now.ToString();
        }
    }

    public static string GetHour()
    {
        return DateTime.Now.Hour.ToString("00") + ":" + DateTime.Now.Minute.ToString("00") + ":" + DateTime.Now.Second.ToString("00");
    }

    public static int GetDay()
    {
        return (int) DateTime.Now.Day;
    }

    public static int GetMonth()
    {
        return (int) DateTime.Now.Month;
    }

    public static int GetYear()
    {
        return (int) DateTime.Now.Year;
    }

    public static int GetDayOfWeek()
    {
        return (int) DateTime.Now.DayOfWeek;
    }

    public static string GetNextMonthStart(DateTime date, int NbMois)
    {
        DateTime _date = date.AddMonths(NbMois);
        return _date.Year.ToString("0000") + "-" + _date.Month.ToString("00") + "-" + "01";
    }

    public static bool IsDate(DateTime date)
    {
        try
        {
            int day = date.Day;
            int month = date.Month;
            int year = date.Year;

            if(month == 2)
            {
                if(day == 30 || day == 31)
                    return false;
                if(day == 29)
                    return ((year%4 == 0 && year%100 != 0) || year%400 == 0);
            }

            if (day == 31)
                return !(month == 4 || month == 6 || month == 9 || month == 11);

            return true;
        }
        catch { return false; }
    }

    public static string GetGuid()
    {
        return Guid.NewGuid().ToString();
    }

     public static DateTime GetDateValue(string sVal)
    {
        DateTime dtRet;
        sVal = sVal.Replace("-", "").Replace("/", "");
        try
        {
            int nAdd = 0;
            if (Convert.ToInt32(sVal.Substring(0, 2)) < 80)
            {
                nAdd = 2000;
            }
            else
            {
                nAdd = 1980;
            }

            if (sVal.Length == 6)
            {
                //YYMMDD
                dtRet = new DateTime(nAdd + Convert.ToInt32(sVal.Substring(0, 2)), Convert.ToInt32(sVal.Substring(2, 2)), Convert.ToInt32(sVal.Substring(4, 2)), 0, 0, 0);
                return dtRet;
            }
            if (sVal.Length == 8)
            {
                if (sVal.IndexOf("-") > 0)
                {
                    //YY-MM-DD
                    dtRet = new DateTime(nAdd + Convert.ToInt32(sVal.Substring(0, 2)), Convert.ToInt32(sVal.Substring(3, 2)), Convert.ToInt32(sVal.Substring(6, 2)), 0, 0, 0);
                    return dtRet;
                }

                //YYYYMMDD
                dtRet = new DateTime(Convert.ToInt32(sVal.Substring(0, 4)), Convert.ToInt32(sVal.Substring(4, 2)), Convert.ToInt32(sVal.Substring(6, 2)), 0, 0, 0);
                return dtRet;
            }
            if (sVal.Length == 10)
            {
                //YYYY-MM-DD
                dtRet = new DateTime(Convert.ToInt32(sVal.Substring(0, 4)), Convert.ToInt32(sVal.Substring(5, 2)), Convert.ToInt32(sVal.Substring(8, 2)), 0, 0, 0);
                return dtRet;
            }
            return Convert.ToDateTime(sVal);
        }
        catch (Exception)
        {
        }
        dtRet = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0);
        return dtRet;
    }

}

CREATE TABLE IF NOT EXISTS `antwoorden` (
  `id` int(11) NOT NULL auto_increment,
  `geslacht` text NOT NULL,
  `studeren` text NOT NULL,
  `geboorteJaar` int(4) NOT NULL default '0',
  `gsm` text NOT NULL,
  `prijsGsmToestel` text,
  `herlaadmanier` text,
  `provider` text,
  `bedragPerMaan` text,
  `smsPerDag` text,
  `belPerDag` text,
  `mp3` text NOT NULL,
  `prijsMp3` text,
  `gebruikMp3` text,
  `pc` text NOT NULL,
  `aantalPc1` text,
  `aantalPc2` text,
  `aantalPc3` text,
  `aantalPc4` text,
  `aantalPc5` text,
  `aantalPc6` text,
  `aantalPc7` text,
  `aantalPc8` text,
  `aantalPc9` text,
  `aantalPc10` text,
  `prijsPc` text,
  `pcWerk` text,
  `pcSchool` text,
  `pcGamen` text,
  `pcFilm` text,
  `pcComm` text,
  `pcSociaal` text,
  `pcMuziek` text,
  `pcAndere` text,
  `pcGebruik` text,
  `pcProvider` text,
  `pc2000` text,
  `pcXp` text,
  `pcVista` text,
  `pc7` text,
  `pcLeo` text,
  `pcSnowLeo` text,
  `pcLinux` text,
  `pcUnix` text,
  `pcAndereBest` text,
  `pda` text NOT NULL,
  `prijsPda` text,
  `pdaWerk` text,
  `pdaSchool` text,
  `pdaGamen` text,
  `pdaAndere` text,
  `pdaGebruik` text,
  `pdaProvider` text,
  `tv` text NOT NULL,
  `tvGebruik` text,
  `tvProvider` text,
  `gamen` text NOT NULL,
  `play1` text,
  `play2` text,
  `play3` text,
  `xbox` text,
  `xbox360` text,
  `psp` text,
  `pspGo` text,
  `gameCube` text,
  `wii` text,
  `ds` text,
  `gameAndere` text,
  `consoleAantal` text,
  `prijsGames` text,
  `digiFoto` text,
  `filmCamera` text,
  `extHD` text,
  `memStick` text,
  `videoRec` text,
  `dvdSpelRec` text,
  `bluRay` text,
  `dlToetsMuis` text,
  `gameToeb` text,
  `surround` text,
  `printer` text,
  `webcam` text,
  `scanner` text,
  `enqueteLeuk` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;