博客

        static void Main(string[] args) {

            DateTime serverTime = getNowServer();
            Console.WriteLine("服务器时间:" + serverTime);
            Console.WriteLine("服务器时间,年份:" + serverTime.Year);
            Console.WriteLine("服务器时间,月份:" + serverTime.Month);
            Console.ReadLine();

            /*  输出结果:
             *  
             *  连接成功
             *  服务器时间:2020/2/22 15:12:35
             *  服务器时间,年份:2020
             *  服务器时间,月份:2
             * */
        }

        public static DateTime getNowServer() {
            
            SqlConnection cnn = new SqlConnection("server=;database=1010数据库2;uid=sa;pwd=897646");
            try {
                cnn.Open();
                Console.WriteLine("连接成功");
            }
            catch (Exception) {
                throw;
            }
            SqlCommand cmd = new SqlCommand(string.Empty, cnn);
            string sql = " Select getDate() ";
            cmd.CommandText = sql;
            DateTime serverDateTime =(DateTime) cmd.ExecuteScalar();
            //Console.WriteLine(serverDateTime);
            return serverDateTime;
        }