[Cialug] [OT] SQL question

[Claus]

On 10/3/2005 3:18 PM, David Stout wrote:
> Is it possible to update a varchar column(empty) with a  timestamp column and truncate the trailing 0’s 
> 
> This would be in DB2.
> 
> Thank you,
> 
> David Stout
> Data Repository Analyst

Of course you can store a time stamp in a varchar field as a text 
string.  DB2 wouldn't treat it as a timestamp though but as a varchar.

Why trunkation of the trailing zeros of the time stamp (ie the fraction 
if it is zero)?

I have the feeling that there is more to the question than I'm reading 
from it.

   Claus