摘要:
1 Console.WriteLine("ToShortDateString:" + DateTime.Now.ToShortDateString()); 2 Console.WriteLine("ToLongDateString:" + DateTime.Now.ToLongDateString()); 3 4 Console.WriteLine("ToShortTimeString:" + DateTime.Now.ToShortTimeString()); 5 Console.WriteLine("ToLongTime 阅读全文
posted @ 2014-03-27 11:21
小川哥
阅读(34708)
评论(2)
推荐(3)
摘要:
--SQL CONVERT日期转换print GETDATE()--相同Select CONVERT(varchar(100), GETDATE(), 0) AS NDateTime --: 05 16 2006 10:57AMSelect CONVERT(varchar(100), GETDATE(), 100) AS NDateTime --: 05 16 2006 10:57AM--年份2或者4位Select CONVERT(varchar(100), GETDATE(), 1) AS NDateTime --: 05/16/06Select CONVERT(varchar(10... 阅读全文
posted @ 2014-03-27 11:01
小川哥
阅读(527)
评论(0)
推荐(0)