| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Yasir Malik <ymalik(at)cs(dot)stevens-tech(dot)edu>, David Olbersen <DOlbersen(at)stbernard(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Datatype conversion help |
| Date: | 2003-07-09 08:29:44 |
| Message-ID: | 200307090929.44336.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Tuesday 08 Jul 2003 10:19 pm, Yasir Malik wrote:
> Yes, Mr. Nachbaur helped me out. Thanks. I don't think I can do
> to_char(<whatever date>, 'MM-DD-YYYY)
> because the date fields are originally stored as separate integers in my
> schema (they have to be that way). I still can't understand why the extra
> space was added after the dash. It just made my life more miserable.
> Yasir
You are not the only one it makes miserable. I believe it's there to provide
compatibility with Oracle/some other db. Their function does it so ours
should too. Very strange behaviour though.
--
Richard Huxton
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rudi Starcevic | 2003-07-09 09:06:46 | Re: Logging select statements |
| Previous Message | Rudi Starcevic | 2003-07-09 06:55:57 | Re: Logging select statements |