Oracle/SqlServer/Access转换成时间的C#生成SQL语句的代码

2017-03-05 08:02:43 访问(2306) 赞(0) 踩(0)


        /// <summary>
        /// 转换时间 
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public static string SqlServerConvertDateTimeToSQL
                (
                    object obj
                )
        {
            if (obj == DBNull.Value || obj == null || obj.ToString().Length == 0)
                return "";

            return " convert(datetime,'" + Convert.ToDateTime(obj).ToString("yyyy-MM-dd HH:mm:ss") + "',20) ";
        }

        /// <summary>
        /// 转换时间 
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public static string OracleConvertDateTimeToSQL
                (
                    object obj
                )
        {
            if (obj == DBNull.Value || obj == null || obj.ToString().Length == 0)
                return "";

            return " to_date('" + Convert.ToDateTime(obj).ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-mm-dd hh24:mi:ss') ";

        }

        /// <summary>
        /// 转换时间 
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public static string AccessConvertDateTimeToSQL
                (
                    object obj
                )
        {
            if (obj == DBNull.Value || obj == null || obj.ToString().Length == 0)
                return "";

            return " cdate('" + Convert.ToDateTime(obj).ToString("yyyy-MM-dd HH:mm:ss") + "') ";
        }