|
|
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
>
Navigation:
[Reply to this message]
|