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
-----------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
