From: | Forgacs Tamas <forgacs(at)negral(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | DATE formatting problem again |
Date: | 2000-02-29 13:29:54 |
Message-ID: | 38BBC9D2.DCB94658@negral.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello,
I am searching after the date formatting solution, but didn't found a
correct one.
So example ORACLE has
- to_char function to make any kind of date format from a date type:
to_char(now,'yyyy.mm.dd')
- to_date to makes a date type from any kind of string: to_date
('1999.11.23','yyyy.mm.dd')
I don't believe that this very easy thing is not made in PostgreSQL. It
can be made as function also, but I have no time to learn PL/pgSQL
languague...
By the way: how can You use wildcards for date type (with to_char is
easy, but without??)
Regards:
FT
!!!PLEASE MAIL THE ANSWER TO ME ALSO: efte(at)negral(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 2000-02-29 14:35:08 | Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returnsmultiples |
Previous Message | Peter Eisentraut | 2000-02-29 11:59:41 | RE: [SQL] prob with aggregate and group by - returns multiples |