Re: dates and selection - Mailing list pgsql-sql

From Josh Berkus
Subject Re: dates and selection
Date
Msg-id 200508182118.21267.josh@agliodbs.com
Whole thread Raw
In response to dates and selection  ("Joel Fradkin" <jfradkin@wazagua.com>)
List pgsql-sql
Joel,

> Now I found I had to do something like this just to have a timestamp
> (problem is I do not want the format of the time stamp, my clients want to
> see the month as a string)

Um, what's wrong with:

to_char(some_timestamp, 'Mon DD YYYY HH:MI:SS') 

?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-sql by date:

Previous
From: "Dmitri Bichko"
Date:
Subject: Re: SQL CASE Statements
Next
From: "Simon Kinsella"
Date:
Subject: PGSQL function for converting between arbitrary numeric bases?