恩。楼上说得对,我也想在数据库中就处理掉,可我一般取数据都直接用色select * from table 怎么做能直接对日期进行处理?
恩,动手改了下 SELECT Post_ID,Convert(Varchar(5),Post_time,110) as Post_time,Post_type,Post_title,Post_hits,Post_reply,Post_author from Postthat's ok ,thanks a lot
那就在程序中用 DateTime类处理
select cast(day(日期) as varchar(30))+'-'+cast(month(日期) as varchar(30))
Select Convert(Varchar(5), GetDate(), 110)
--Result
/*
08-25
*/
currentTime=myreader["datetime"];
int month,day;
month=currentTime.Month;
day=currentTime.Day;
string abc=month.ToString()+"_"+day.ToString();
可以!
怎么做能直接对日期进行处理?
SELECT Post_ID,Convert(Varchar(5),Post_time,110) as Post_time,Post_type,Post_title,Post_hits,Post_reply,Post_author from Postthat's ok ,thanks a lot