El Sáb 03 Ene 2004 18:20, ivan escribió:
> ok, bat each time where i want to do select .. a nie tu use to_char,
> but it should be in function timestamp_out to convert time to string
> it would be easer and faster.
Look deeper into what Christopher said and use casting to get the right
output:
prueba=> select now(); now
-------------------------------2004-01-04 09:53:41.131079-03
(1 row)
prueba=> select now()::timestamp(0); now
---------------------2004-01-04 09:53:43
(1 row)
Get the difference?
-- 09:52:01 up 39 days, 16:08, 2 users, load average: 0.60, 0.71, 0.72
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral
-----------------------------------------------------------------