时间加秒的问题

Question

09/09/2009 12:00:00 + 509/09/2009 12:00:05(datetime)请教怎么实现

Answer 1

        static void Main(string[] args)
        {
            DateTime dt = new DateTime(2009, 9, 9, 12, 0, 0);
            DateTime dt1 = dt.AddSeconds(5);
            Console.WriteLine(dt1.ToString());
            Console.ReadLine();
        }

Answer 2

declare @time datetime
set @time='2009-09-09 12:00:000'
select Dateadd(s,5,@time)
/*
2009-09-09 12:00:05.000
*/