[Cialug] SQL question

[David Stout]

I have a timestamp like 2004-12-01 00:00:01.0000 and I need this 2004-12-01 00:00:1
I need to drop the zero before the 1 and all of them after it.

David Stout
Data Repository Analyst
----- Original Message -----
From: David Stout [mailto:david.stout at marshallnet.com]
Sent: 10/3/2005 3:18:45 PM
To: cialug at cialug.org
Subject: [Cialug] SQL question

> 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
> 
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
>