RE: Without using sysdate

From: William Beilstein <BeilstWH_at_obg.com>
Date: Tue, 13 Jun 2000 14:46:35 -0400
Message-Id: <10527.109032@fatcity.com>

People have been trying to answer this question, but the real question is = why they don't want to use sysdate. If we know, we could make a better = guess on what they need.

>>> "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM> 06/13/00 02:46PM >>> A good guess would be one of the date columns in one of the v$<tables> = that
keep changing with time.
e.g. checkpoint or SCN

-----Original Message-----
Sent: Tuesday, June 13, 2000 12:27 PM
To: Multiple recipients of list ORACLE-L

Write an external C procedure to use localtime and=20 return the current month.

Not sure what the value is in this though. Using=20 SYSDATE would be faster.

Jared

On Mon, 12 Jun 2000, Veera Prasad wrote:

> Can anybody teach me how to findout current month
> without using sysdate.

>=20

> Regards
> Veera

>=20

> --=20
> Author: Veera Prasad
> INET: vprasad_at_olf.com=20

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>=20

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address jkstill_at_teleport.com - private

--=20
Author: Jared Still
INET: jkstill_at_bcbso.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --=20
Author: Khedr, Waleed
INET: Waleed.Khedr_at_FMR.COM=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------