Posted by Roy Harvey on 01/04/07 14:33

OK, let me see if I understand this. Have I identified the row that
need fixing correctly? I chose the one row that ended before it
started.

>dateid date starttime endtime
>
>458 2006-12-29 22:00 23:15
>458 2006-12-29 00:15 01:30
>459 2006-12-30 20:00 21:10
>459 2006-12-30 22:15 23:35
>459 2006-12-30 23:30 00:40 --Problem?
>459 2006-12-30 01:50 02:30

If that is not correct, please mark which ones have the problem and
what rule was made it so.

Roy Harvey
Beacon Falls, CT

On Thu, 4 Jan 2007 14:47:28 +0100, "Grey" <null@null.null> wrote:

>
>> I'm a bit confused. You mention that it uses a datetime data type,
>> but the data shows appears to be a column with a date and no time, and
>> two columns with time but no date. Datetime always has both.
>>
>> Roy Harvey
>> Beacon Falls, CT
>
>The fields are presented for simplicity. they have both date and time, but
>the front end adds only time, so the datepart of the filed is disregarded.
>Any way it contains a wrong value for operations past midnight.
>
>Grey
>

[Back to original message]