private static string DateAdd(DateTimePart part, string dt, string n)
{
switch (part)
{
case DateTimePart.Month:
case DateTimePart.Year:
return(string.Format("(add_months({0}, {1}))", dt, part == DateTimePart.Month ? n : "12 * " + n));
default:
return(string.Format("({0} + numtodsinterval({1}, '{2}'))", dt, n, part.ToString().ToUpper()));
}
}
private static string Extract(DateTimePart part, string dt)
{
switch (part)
{
case DateTimePart.Hour:
return(string.Format("to_number(to_char({0}, 'HH24'))", dt));
case DateTimePart.WeekDay:
return(string.Format("(to_number(to_char({0}, 'D')) - 1)", dt));
default:
return(string.Format("extract({0} FROM {1})", part.ToString().ToLower(), dt));
}
}
private static string DatePart(DateTimePart part, string dt)
{
return(string.Format("datepart({0}, {1})", part.ToString().ToLower(), dt));
}
private static string DateDiff(DateTimePart part, string dt1, string dt2)
{
return(string.Format("datediff({0}, {1}, {2})", part.ToString().ToLower(), dt1, dt2));
}
private static string DateAdd(DateTimePart part, string dt, string n)
{
return(string.Format("dateadd({0}, {1}, {2})", part.ToString().ToLower(), n, dt));
}
private static string DateDiff(DateTimePart part, string dt1, string dt2)
{
return(string.Format("TIMESTAMPDIFF({0}, {1}, {2})", part.ToString().ToUpper(), dt1, dt2));
}
private static string DateAdd(DateTimePart part, string dt, string n)
{
return(string.Format("DATE_ADD({0}, INTERVAL {1} {2})", dt, n, part.ToString().ToUpper()));
}
private static string DateAdd(DateTimePart part, string dt1, string n)
{
return(string.Format("DATEADD({0},{1},{2})", part.ToString().ToUpper(), dt1, n));
}
