i know, but i talking about default time output, it would be for time, date and date with time, not formating all the time.
On Sun, 4 Jan 2004, Tom Lane wrote: > Martin Marques <[EMAIL PROTECTED]> writes: > > Look deeper into what Christopher said and use casting to get the right > > output: > > prueba=> select now()::timestamp(0); > > There's also "current_timestamp(0)", which is a more standards-compliant > way of doing the same thing. > > regards, tom lane > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html