Padding time values from EXTRACT()

Поиск
Список
Период
Сортировка
Искать
От
Mark Kelly
Тема
Padding time values from EXTRACT()
Дата
Msg-id
200911190015.38074.pgsql@wastedtimes.net
Список
Дерево обсуждения
Padding time values from EXTRACT() Mark Kelly <pgsql@wastedtimes.net>
Re: Padding time values from EXTRACT() Tom Lane <tgl@sss.pgh.pa.us>
Re: Padding time values from EXTRACT() Mark Kelly <pgsql@wastedtimes.net>
Re: Padding time values from EXTRACT() Steve Crawford <scrawford@pinpointresearch.com>
Hi.

If I use the following snippet

EXTRACT (hour FROM timestamp) || ':' || 
EXTRACT (minute FROM timestamp) 
AS this_time

I get single digit figures returned for minutes less than 10, resulting in the 
odd-looking 12:5 when I was expecting 12:05. 

Actual column value is '2009-11-18 12:05:31.030546', which I why I assumed I'd 
get the 0 in the returned value.

Is there any way to zero pad the only the values below 10 so I always get two 
character responses for the minutes?

Thanks,

Mark
В списке pgsql-novice по дате отправления
От: Richard Broersma
Дата:
Сообщение: Re: Introduction
От: Tom Lane
Дата:
FAQ