public string ConvertToSql(object value, DbType targetDbType) { if (targetDbType == DbType.DateTime) { return(string.Format(CultureInfo.InvariantCulture, "TO_DATE('{0}','DD-MON-YYYY HH24:MI:SS')", ((DateTime)value).ToString("dd-MMM-yyyy HH:mm:ss", CultureInfo.InvariantCulture))); } return(SqlScriptingHelper.ToSql(value, targetDbType, PrefixUnicodeLiterals)); }
public string ConvertToSql(object value, DbType targetDbType) { if (targetDbType == DbType.DateTime) { return(string.Format(CultureInfo.InvariantCulture, "TIMESTAMP '{0}'", ((DateTime)value).ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture))); } return(SqlScriptingHelper.ToSql(value, targetDbType)); }
public string ConvertToSql(object value, DbType targetDbType) { return(SqlScriptingHelper.ToSql(value, targetDbType, PrefixUnicodeLiterals)); }
public string ConvertToSql(object value, DbType targetDbType) { return(SqlScriptingHelper.ToSql(value, targetDbType)); }