Re: time format
От
Martin Marques
Тема
Re: time format
Дата
Msg-id
200401040954.25708.martin@bugs.unl.edu.ar
Ответ на
Re: time format (ivan)
Список
Дерево обсуждения
time format ivan <iv@psycho.pl>
Re: time format Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: time format ivan <iv@psycho.pl>
Re: time format Kurt Roeckx <Q@ping.be>
Re: time format ivan <iv@psycho.pl>
Re: time format Martin Marques <martin@bugs.unl.edu.ar>
Re: time format Tom Lane <tgl@sss.pgh.pa.us>
Re: time format Martin Marques <martin@bugs.unl.edu.ar>
Re: time format ivan <iv@psycho.pl>
Re: time format Karel Zak <zakkr@zf.jcu.cz>
Re: time format ivan <iv@psycho.pl>
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 -----------------------------------------------------------------
В списке pgsql-hackers по дате отправления
