Update a DATETIME field

Hi...

I have entered a value like: INSERT INTO r
VALUES(1,CURRENT_TIMESTAMP);

What I am curious to know is if there is a way to just change the TIME
value of the existing record, or must I keep 2-separate fields with
DATE and TIME datatypes?

Thanks,
Joe

On 16 Oct, 16:55, JoeT <trub...@yahoo.com> wrote:
> Hi...
>
> I have entered a value like: INSERT INTO r
> VALUES(1,CURRENT_TIMESTAMP);
>
> What I am curious to know is if there is a way to just change the TIME
> value of the existing record, or must I keep 2-separate fields with
> DATE and TIME datatypes?
>
> Thanks,
> Joe

Something like
UPDATE r SET my_time_field = TIMESTAMPADD(MINUTE,1,my_time_field);