Re: dates and selection

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Cc: "Joel Fradkin" <jfradkin(at)wazagua(dot)com>
Subject: Re: dates and selection
Date: 2005-08-19 04:18:21
Message-ID: 200508182118.21267.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc 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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Andreas Pflug 2005-08-19 08:35:28 Re: Bug or not about ASCII and Multi-Byte character set
Previous Message Scot Loach 2005-08-19 00:41:31 Re: changed behavior in libpq odbc driver

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2005-08-19 05:02:31 Re: Tables are not being updated Properly through Trigger
Previous Message Dmitri Bichko 2005-08-19 01:56:17 Re: SQL CASE Statements