摘要:
使用 CONVERT:select convert(datetime ,'20080531',120)---字符转换成日期CONVERT (data_type[(length)], expression [, style])select CONVERT(varchar, getdate(), 120 ) 2004-09-12 11:06:08select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),\'-\',\'\'),\' \',\'\') 阅读全文
摘要:
DateTime dt = DateTime.Now;//Label1.Text = dt.ToString();//2005-11-5 13:21:25//Label2.Text = dt.ToFileTime().ToString();//127756416859912816//Label3.Text = dt.ToFileTimeUtc().ToString();//127756704859912816//Label4.Text = dt.ToLocalTime().ToString();//2005-11-5 21:21:25//Label5.Text = dt.ToLongDate. 阅读全文