<html>
<head>
<style type="text/css">
<!--
body { font-variant: normal; margin-top: 4px; margin-left: 4px; line-height: normal; margin-bottom: 1px; margin-right: 4px }
-->
</style>
</head>
<body style="margin-top: 4px; margin-left: 4px; margin-right: 4px; margin-bottom: 1px">
<DIV> It is generally considered "best practice" to store data in the
</DIV>
<DIV>default form, and reformat it as needed. In your case, I would
</DIV>
<DIV>store the data as a timestamp and write an accessor function
</DIV>
<DIV>or view that gives you the format you want.
</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><br><br><br>-- <br>-Josh More, RHCE, CISSP, NCLP<br> morej@alliancetechnologies.net<br> 515-245-7701<br><br>>>>david.stout@marshallnet.com 10/04/05 9:11 am >>><br>I have a timestamp like 2004-12-01 00:00:01.0000 and I need this 2004-12-01 00:00:1<br>I need to drop the zero before the 1 and all of them after it.<br><br>David Stout<br>Data Repository Analyst<br>----- Original Message -----<br>From: David Stout [mailto:david.stout@marshallnet.com]<br>Sent: 10/3/2005 3:18:45 PM<br>To: cialug@cialug.org<br>Subject: [Cialug] SQL question<br><br>>Is it possible to update a varchar column(empty) with a  timestamp column and truncate the trailing 0’s<br>><br>>This would be in DB2.<br>><br>>Thank you,<br>><br>>David Stout<br>>Data Repository Analyst<br>><br>><br>>Cialug mailing list<br>>Cialug@cialug.org<br>>http://cialug.org/mailman/listinfo/cialug<br>><br><br><br>Cialug mailing list<br>Cialug@cialug.org<br>http://cialug.org/mailman/listinfo/cialug<br> </DIV>
</body>
</html>