[freeside] date format style

[ivan at 420.am]

On Fri, Aug 16, 2002 at 01:29:31AM -0700, baloo at gimpgirl.com wrote:
> On Thu, 15 Aug 2002, David B. Hughes wrote:
> 
> > What sql command would I need to convert the ten digit
> > time/date from "cust_credit" column "cust_credit_date"
> > into this format.
> > 08/15/02
> 
> select web_page from the_postgres_online_doc_web_site where url =
> 'http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/sql-set.html';

Hmm, I can't see that includes any documentation on how to convert from 
UNIX integer timestamps to a formatted date.

In Perl, see Date::Format

I'd be interested hearing about an SQL equivalent.  I don't know of one 
offhand.

-- 
_ivan