Re: Problem with timestamp - Pls help

"Kumar"  writes:
> I wanted to update one column of my table with now() or timestamp. And I wa=
> nt that timestamp of format ------------------------
>  2003-09-19 18:39:08.13

It sounds like you simply want to limit the fractional precision of the
value.  Why don't you just declare the column as timestamp(2) ?  All
this fooling around with substrings is inefficient and doesn't have much
to do with your real intent anyhow.
		regards, tom lane