<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=big5">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:SimSun;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:"\@SimSun";
panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:Arial;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{font-family:Arial;
color:windowtext;}
@page Section1
{size:595.45pt 841.7pt;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
11.0pt'>If we find the date difference between two dates using datediff
function, it may end up an inaccurate difference. For example, the start
date is </span></font><span lang=EN-GB>1 July, 2003</span><span lang=EN-GB> and
the end date is </span><span lang=EN-GB>5 July, 2003</span><span lang=EN-GB>.
The difference is 5 days. The answer may be right or wrong. If the
start date is </span><span lang=EN-GB>1 July 2003</span><span lang=EN-GB> </span><span lang=EN-GB>00:00</span><span lang=EN-GB> and the end date is </span><span lang=EN-GB>6 July 2003</span><span lang=EN-GB> </span><span lang=EN-GB>00:00</span><span
lang=EN-GB>. The accurate answer should be 3-5 days. If we ask the
staff to record the time of start date and end date, human delay and error may
happen too unless there is an aid of time recorder. I would like to know
the general perception of this issue.</span></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
11.0pt'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
11.0pt'>Thanks,</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
11.0pt'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
11.0pt'>Ray </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
11.0pt'> </span></font></p>
</div>
</body>
</html>