如题!谢谢您的回复!
解决方案 »
- 如何安装DELPHI的最新控件XPMENU3.1
- socketconnection 服务端放在WIN7\8和互联网上是,客户端连接不上
- 同时运行程序两下,如何实现两个程序间的焦点切换
- ***sos***:请提供晋中级职称可发表论文的报刊杂志!
- 请教小小小问题~。~谢啦
- delphi里excel数据如何导到sqlserver 高分!!!
- 怎样在treeview1中调用word文档时,使鼠标无法按住左键移动(即不准选中文字),主要是防止复制?
- DBTree算法
- 请问关于工具栏的问题
- 循环设置控件的属性
- delphi程序中用了RainXp和FlatStyle控件,但在别人的机子上不能运行,是什么原因如何解决?
- 请教一个查询语句,我查了好些资料,没有搞定
t:TDateTime
begin
t:=StrToDateTime('2003-02-03 10:23:23');
end;
tNow,tDate:TDateTime
begin
tNow:=now();//当前日期和时间
tDate:=date();//当前日期
end;
t:TDateTime
begin
t:=StrToDateTime('2003-02-03');
end;
2.75 1/1/1900 6:00 pm
-1.25 12/29/1899 6:00 am
35065 1/1/1996 12:00 am
To find the fractional number of days between two dates, simply subtract the two values, unless one of the TDateTime values is negative. Similarly, to increment a date and time value by a certain fractional number of days, add the fractional number to the date and time value if the TDateTime value is positive.
When working with negative TDateTime values, computations must handle time portion separately. The fractional part reflects the fraction of a 24-hour day without regard to the sign of the TDateTime value. For example, 6:00 am on 12/29/1899 is ?.25, not ? + 0.25, which would be ?.75. There are no TDateTime values between ? and 0.
sql语句中可以用to_date(str,格式)来写