On Nov 28, 2007, at 14:00 , Erik Jones wrote:
> Why not just:
>
> UPDATE table
> SET mytime=NULL
> WHERE mytime='';
If mytime is a timestamp field, it won't have any values ''. I
believe the OP is updating mytime to a client-supplied value which is
passing '' when it probably means NULL.
Michael Glaesemann
grzm seespotcode net