求一算法,难吗?不难,可是没有想出来 2005-01-20 12:32:37 -------> 1106195557 2005-01-20 12:28:12 -------> 11061952922005-01-20 12:35:59 -------> 1106195759通过什么算法得到把时间转换成后面的数字?????????????? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 应该是C语言的时间吧, 1970-01-01 00:00 起过去的秒数. 也就是round((date-strtodatetime('1970-01-01 00:00')) * 86400) 1.用select datediff(second, '2005-01-20 12:28:12', '2005-01-20 12:32:37')算出差265秒,1106195292-1106195557=265,所以应该是用时间减去一个值得出和秒,再看一下! procedure TForm1.Button1Click(Sender: TObject);var lDouble: Double;begin lDouble := SecondSpan(StrToDateTime('2005/01/20 12:32:37'),StrToDateTime('1970/01/01 00:00:00')); ShowMessage(FloatToStr(lDouble));end; 找到规律:select datediff(second, '1970-01-01 08:00', '2005-01-20 12:32:37')--1106195557select datediff(second, '1970-01-01 08:00', '2005-01-20 12:28:12')--1106195292select datediff(second, '1970-01-01 08:00', '2005-01-20 12:35:59')--1106195759 uses DateUtils;procedure TForm1.Button1Click(Sender: TObject);var lDouble: Double;begin lDouble := SecondSpan(StrToDateTime('2005/01/20 12:35:59') , StrToDateTime('1970/01/01 8:00')); ShowMessage(FloatToStr(lDouble));end; 再RzPageControl中释放EmbeddedWB报错 在D2007下用dbexpress连mysql5.0.48,怎么解决取出中文乱码问题? 结交朋哟,散分! 急问fastreport收费问题!! 有没有能做出类似qq聊天记录形式的控件呢?着急 help 关于C与Delphi的问题,UP有分! 请教在statusbar中加入ProgressBar! 请问:如何使在DBGRID或STRINGGRID等表格控件的一个CELLS中能够显示或编辑多行文本? XE2 中如何新建Web app Debugger executable 一个简单的数据库问题 字符排序
round((date-strtodatetime('1970-01-01 00:00')) * 86400)
算出差265秒,
1106195292-1106195557=265,
所以应该是用时间减去一个值得出和秒,再看一下!
var
lDouble: Double;
begin
lDouble := SecondSpan(StrToDateTime('2005/01/20 12:32:37'),StrToDateTime('1970/01/01 00:00:00'));
ShowMessage(FloatToStr(lDouble));
end;
--1106195557select datediff(second, '1970-01-01 08:00', '2005-01-20 12:28:12')
--1106195292select datediff(second, '1970-01-01 08:00', '2005-01-20 12:35:59')
--1106195759
var
lDouble: Double;
begin
lDouble := SecondSpan(StrToDateTime('2005/01/20 12:35:59')
, StrToDateTime('1970/01/01 8:00'));
ShowMessage(FloatToStr(lDouble));
end;