Re: Padding time values from EXTRACT()

From: Mark Kelly <pgsql(at)wastedtimes(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Padding time values from EXTRACT()
Date: 2009-11-19 00:42:26
Message-ID: 200911190042.26821.pgsql@wastedtimes.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi Tom.

On Thursday 19 Nov 2009 at 00:37 Tom Lane wrote:
> Use to_char() for this sort of thing. Something like
> to_char(now(), 'HH24:MM') is probably what you want here.

Oh whoops. I just realised that was linked from the page I found extract() on.
Guess it's obvious now why I'm on the novice list :)

Thank you for taking the time to reply,

Mark

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Steve Crawford 2009-11-19 01:13:05 Re: Padding time values from EXTRACT()
Previous Message Tom Lane 2009-11-19 00:37:23 Re: Padding time values from EXTRACT()