1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
|
// Format de date pour base Access
public static string SQLDate(DateTime datDAte)
{
string strDate = string.Empty;
try
{
strDate = "#" + datDAte.Month + "/" + datDAte.Day + "/" + datDAte.Year + "#";
}
catch
{
}
return strDate;
}
public static string SQLDateHeure(DateTime datDAte)
{
string strDateHeure = string.Empty;
try
{
strDateHeure = "#" + datDAte.Month + "/" + datDAte.Day + "/" + datDAte.Year + " " +
datDAte.Hour + ":" + datDAte.Minute + ":" + datDAte.Second + "#";
}
catch
{
}
return strDateHeure;
}
public static string SQLHeure(DateTime datDAte)
{
string strHeure = string.Empty;
try
{
strHeure = "#" + datDAte.Hour + ":" + datDAte.Minute + ":" + datDAte.Second + "#";
}
catch
{
}
return strHeure;
} |