用sqlserver里提供的函数
DATEDIFF(day,date1,date2)*24
DATEDIFF(day,date1,date2)*24
解决方案 »
- 如何调整TQRChart的Axis的title和label之间的距离?
- checkbox 只读
- dephi7中如何控制电脑发出蜂鸣声(机器自带的扬声器)
- 如何在程序中调用相应的程序打开一个文件?(内详)
- 求教字符串转化问题
- 请教:在ListView中怎样可以任意拖动这些图标呢?多谢!
- 如何分析、解决写二进制字段(image类型)对长度的限制(希望数据库老手帮我分析一把)?
- 请问高手~~数据库问题
- 怎么读取windows剪贴板里的图片
- 各位大虾,谁能给我一个sncCurrency财务凭证控件,先用100大洋做酬谢!!
- 请问:TEdit(...).Focus之后,如何让光标显示在指定位置
- 在ClientDataset控件中已经把数据查询出来了,如何把它做成本地的paradox数据库表,谢谢!!
inthh:= strtoint(formatdatetime(time1,hh)-formatdatetime(time2,hh));
your result:=inthh+decHH;
(日期1-日期2)/(1/24)
如果是字符串,用StrToDatetime尝试转换。
{ Range query functions }function YearsBetween(const ANow, AThen: TDateTime): Integer;
function MonthsBetween(const ANow, AThen: TDateTime): Integer;
function WeeksBetween(const ANow, AThen: TDateTime): Integer;
function DaysBetween(const ANow, AThen: TDateTime): Integer;
function HoursBetween(const ANow, AThen: TDateTime): Int64;
function MinutesBetween(const ANow, AThen: TDateTime): Int64;
function SecondsBetween(const ANow, AThen: TDateTime): Int64;
function MilliSecondsBetween(const ANow, AThen: TDateTime): Int64;
{ YearSpan and MonthSpan are approximates, not exact but pretty darn close }
function YearSpan(const ANow, AThen: TDateTime): Double;
function MonthSpan(const ANow, AThen: TDateTime): Double;
function WeekSpan(const ANow, AThen: TDateTime): Double;
function DaySpan(const ANow, AThen: TDateTime): Double;
function HourSpan(const ANow, AThen: TDateTime): Double;
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
function MinuteSpan(const ANow, AThen: TDateTime): Double;
function SecondSpan(const ANow, AThen: TDateTime): Double;
function MilliSecondSpan(const ANow, AThen: TDateTime): Double;
function SpanOfNowAndThen(const ANow, AThen: TDateTime): TDateTime;
begin
if ANow < AThen then
Result := AThen - ANow
else
Result := ANow - AThen;
end;function HourSpan(const ANow, AThen: TDateTime): Double;
const
HoursPerDay = 24;
begin
Result := HoursPerDay * SpanOfNowAndThen(ANow, AThen);
end;
把时间变成TDATEIME类型
再把两个浮点类型一减 呵呵成了:)