Home > mailing lists

Getting time from date field - Mailing list pgsql-general

From	Alejandro Javier Pomeraniec
Subject	Getting time from date field
Date	November 5, 2003 19:04:42
Msg-id	20031105171212.06ae32ca.apomeraniec@buenosaires.gov.ar Whole thread Raw
Responses	Re: Getting time from date field (Bruno Wolff III <bruno@wolff.to>) Re: Getting time from date field (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List	pgsql-general

Hi !

Is there any way to get the time like the following example ?

'2003-05-11 15:21:21'

should return

'15:21:21'


Thanks !!

From: "Simon Stiefel"
Date: 05 November 2003, 18:53:57
Subject: Question on database structure

From: George Essig
Date: 05 November 2003, 19:27:37
Subject: tsearch2 and gist index bloat