"Kumar" <sgnerd(at)yahoo(dot)com(dot)sg> 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