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)); }