From: | Jeff Davis <jeff95350(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] formatting dates? |
Date: | 2000-02-10 01:06:58 |
Message-ID: | 20000210010658.11583.qmail@web3002.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I don't know about the date formatting (although I
know that can always be done easily on the application
end, which is usually more convenient), but about the
regex:
They should work pretty much like perl (there may be a
few differences) except that you aren't retrieving
matches in PG or replacing, it is just a boolean test
to see if a pattern is found.
here is some brief documentation on perl regexes, to
get you started at least:
http://www.perl.com/pub/doc/manual/html/pod/perlre.html#Regular_Expressions
Hope it helps. You might also try documentation for
other programming languages that use regexes (PHP, Sed
& Awk, etc).
-Jeff Davis
--- Frank R Callaghan <f(dot)callaghan(at)ieee(dot)org> wrote:
> Excuse my ignorance but is there anyway to
> format a returned date aka 'mm/dd/yy' in a query
> like
> sybase dateformat(date, 'mm/dd/yy');
> also is the a good document explaining the use
> of regex in postgresql.
>
> TIA,
> Frank.
>
>
>
>
>
>
> ************
>
>
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | john huttley | 2000-02-10 04:16:52 | Re: [GENERAL] How can we do STORED PRECEDURE in PostgreSQL? |
Previous Message | Jackson, Kevin J. | 2000-02-09 22:17:02 | FW: [GENERAL] "document contains no data" |