Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> 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