"Kumar" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
