in order to get the Date and time parts of each timestamp field try casting
them
like this:

update table1
set logindate = cast (login as date), logintime= cast(login as time) etc.

I hope i helped with this


Tasos Kyriakos
Athens, Greece