Mark Kelly wrote:
> 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?
This is much simpler with "to_char(timestamp, format)":
select to_char(now(), 'HH:MM');
select to_char(now(), 'HH24:MM');
select to_char(now(), 'FMHH:MM');
In response to
pgsql-novice by date
|Next:||From: Mazen Abdel-Rahman||Date: 2009-11-19 04:14:42|
|Subject: Using file data as argument to functions called from psql command line|
|Previous:||From: Mark Kelly||Date: 2009-11-19 00:42:26|
|Subject: Re: Padding time values from EXTRACT()|