No thoughts today. I'm just too Lazy to dwell on that. But let me know
who wins.
John P. Kruger
DB2 Performance on AIX
-----Original Message-----
From: Doug Kostelnik
[mailto:db2udbdba-ezmlmshield-x73062046.[Email address protected]
Sent: Wednesday, May 31, 2006 3:44 PM
To: LazyDBA Discussion
Subject: Silly question # x(n-1)^n
Hello Everyone,
I've been "not lazy" and have been looking-up the answer to the
following question:
When does the new day begin - in timestamp format? I was always taught
that as the clock hit midnight (00:00:00 or 24:00:00) that it was zero
hour of the new day. That would mean that a day would be
2006-05-31-00.00.00.000000 to 2006-05-31-23.59.59.999999 would be all
the time units that would make up the day of 31May06.
I've got a number of programmers that consider 24:00:00.000000 to be the
last time unit of the day. I haven't quite sorted out their logic, but
they balked when I said 24:00:00 and 00:00:00 were the same time when
they were arguing that 2006-05-31-00.00.00.000000 to
2006-05-31-24.00.00.000000 was the valid range.
Any thoughts?
Douglas Kostelnik
Senior Database Administrator/Architect
AAA Auto Club South
<html>
<p class=MsoNormal> <align=justify> <font size=3 face="Times New
Roman"><span style='font-size:12.0pt'><br>
_____________________________________________________________<br>
The information transmitted is intended only for the person(s) or entity
to which it is addressed and may contain confidential and or privileged
material and should be treated as a confidential AAA Auto Club South
communication. If the reader of this message is not the intended
recipient, you are hereby notified that your access is unauthorized, and
any review, dissemination, distribution or copying of this message
including any attachments is strictly prohibited. If you are not the
intended recipient, please contact the sender and delete the material
from any computer.</span></font></p> </html>
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page