public static string OracleTime(string dateTime, OracleDateFormat oracleDate)
{
string _oracleDateTimeFormate = string.Empty;
switch (oracleDate)
{
case OracleDateFormat.OracleTime:
_oracleDateTimeFormate = "To_Date('" + dateTime + "','" + Global.OracleDateFormat + "')";
break;
}
return(_oracleDateTimeFormate);
}
public static string OracleDateTimeFormat(string dateTime, OracleDateFormat oracleDate)
{
string _oracleDateTimeFormate = string.Empty;
switch (oracleDate)
{
case OracleDateFormat.OracleDateTime:
_oracleDateTimeFormate = "To_Date('" + dateTime + "','" + Global.OracleDateTimeFormat + "')";
break;
case OracleDateFormat.OracleDate:
string str = Convert.ToDateTime(dateTime).ToString("dd/MMM/yyyy");
_oracleDateTimeFormate = "To_Date('" + str + "','" + Global.OracleDateFormat + "')";
break;
}
return(_oracleDateTimeFormate);
}