Helen Borrie wrote:

> At 09:56 PM 3/11/2003 -0500, you wrote:
>
>
>>Hello all,
>>
>>Is there a way to insert the current time into a timestamp field is is
>>null? For instance,
>>
>>SELECT Time1, Time2 FROM MyTabe;
>>
>>If either the values is null, I would like to have the curren time
>>filled in...
>
>
> What database and version?
>
> And do you mean you want to *store* current time automatically if null, or
> you want to *output* current time if null is stored?
>

Hi Helen,

Sorry, I should have been more clear. I am using 1.5 RC6 and I would
like the value to be visible within the query without saving the value
to the db if that is possible.

Thanks again,

--

Warm Regards,

Lee