Posted by Roy Harvey on 01/04/07 00:03

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

On Thu, 4 Jan 2007 00:26:39 +0100, "Grey" <null@null.null> wrote:

>I have following problem:
>
>table includes times for startup and end of operation as datetime field
>related to daily shift operations:
>
>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
>459 2006-12-30 01:50 02:30
>
>records are inserted for a date related to begining of the shift, although
>some operations are performed also past the midnight (actualy next day, ex:
>2006-12-31), but belongs to same shift (group)
>
>Now I need to build a function that corrects (updates) the date of every
>operation recorded after midnight to a date+1 value, so all records related
>to same groups (458, 459, etc) that starts after midnight has correct date.
>
>The procedure has to update already exiting table.
>
>Any solution?
>Grey
>

[Back to original message]