[freeside] date format style

[baloo at gimpgirl.com]

On Fri, 16 Aug 2002 ivan at 420.am wrote:

> On Fri, Aug 16, 2002 at 01:29:31AM -0700, baloo at gimpgirl.com wrote:
> > On Thu, 15 Aug 2002, David B. Hughes wrote:
> >
(snipped misread/half-read question)
> >
> > 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.

*sigh* "Self?" "Hmm?" "Don't *LART* answer questions *LART* before coffee.
*LART* *LART* *LART*"

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

Postgresql has a timestamp type. It uses a different origin than Unix
timestamps (January 1, 2000 at some unspecified, but figureable, time and
timezone), but converting to them, and then to a date type, should be
possible.