On Aug 3, 2004, at 4:22 PM, Pedro B. wrote:

Is it possible to make it something like 'yyyy-mm-dd hh:mm:ss:cc' ? (basically, a DATE and a TIME, but with 2 decimal cases on the :cc and not .ccccc as the TIME format.

timestamp and timestamptz both take an optional precision parameter. What you want is timestamp(2) or timestamptz(2), I believe.


Michael Glaesemann
grzm myrealbox com


---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to