如何以得体的格式显示日期和时间
本文关键字:显示 日期 时间 格式 | 更新日期: 2023-09-27 18:19:25
如果我想从数据库中检索日期和时间并以格式
显示它"2分钟前,刚刚,或6个月前"之类的,
我怎么能做…:)
谁能告诉我该怎么做?
string gettime(DateTime updatedat)
{
string toren = "A moment earlier";
TimeSpan ts = DateTime.Now - updatedat;
if (ts.TotalSeconds<60)
{
toren = ts.TotalSeconds.ToString() + " seconds ago";
}
else if (ts.TotalMinutes < 60)
{
toren = ts.TotalMinutes.ToString() + " minutes ago";
}
else if (ts.TotalHours < 24)
{
toren = ts.TotalHours.ToString() + " hours ago";
}
else if (ts.TotalDays < 30)
{
toren = ts.TotalDays.ToString() + " days ago";
}
else
{
double month = ts.TotalDays / 30;
if (month<13)
{
toren = month.ToString() + " months ago";
}
else
{
double year = month / 12;
toren = year.ToString() + " years ago";
}
}
return toren;
}
根据您的需要更改/优化
引用这里的答案:
const int SECOND = 1;
const int MINUTE = 60 * SECOND;
const int HOUR = 60 * MINUTE;
const int DAY = 24 * HOUR;
const int MONTH = 30 * DAY;
if (delta < 0)
{
return "not yet";
}
if (delta < 1 * MINUTE)
{
return ts.Seconds == 1 ? "one second ago" : ts.Seconds + " seconds ago";
}
if (delta < 2 * MINUTE)
{
return "a minute ago";
}
if (delta < 45 * MINUTE)
{
return ts.Minutes + " minutes ago";
}
if (delta < 90 * MINUTE)
{
return "an hour ago";
}
if (delta < 24 * HOUR)
{
return ts.Hours + " hours ago";
}
if (delta < 48 * HOUR)
{
return "yesterday";
}
if (delta < 30 * DAY)
{
return ts.Days + " days ago";
}
if (delta < 12 * MONTH)
{
int months = Convert.ToInt32(Math.Floor((double)ts.Days / 30));
return months <= 1 ? "one month ago" : months + " months ago";
}
else
{
int years = Convert.ToInt32(Math.Floor((double)ts.Days / 365));
return years <= 1 ? "one year ago" : years + " years ago";
}
是的,我引用。因为这个答案正是PO想要的。:)
编辑:PO的问题:还有一件事…如果我从数据库检索日期和时间字段。我该如何暗示这段代码?
不知道你的结构或代码,它看起来像这样:
var cmd = new SqlCommand(yourConnection);
cmd.CommandText = "SELECT yourDateColumn FROM yourTable";
using (var sr = cmd.ExecuteReader)
{
if (sr.Read)
{
var yourDateTime = sr.GetDateTime(0);
}
}