I would assume this is an oracle application. If so use sysdate else write a
C routine as suggested.
Why do you not want to use SYSDATE?
> -----Original Message-----
> From: Khedr, Waleed [SMTP:Waleed.Khedr_at_FMR.COM]
> Sent: Tuesday, June 13, 2000 2:46 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Without using sysdate
>
> 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
> return the current month.
>
> Not sure what the value is in this though. Using
> 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.
> >
> > Regards
> > Veera
> >
> > --
> > Author: Veera Prasad
> > INET: vprasad_at_olf.com
> >
> > 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).
> >
>
>
> 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
>
>
> --
> Author: Jared Still
> INET: jkstill_at_bcbso.com
>
> 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).
> --
> Author: Khedr, Waleed
> INET: Waleed.Khedr_at_FMR.COM
>
> 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
Received on Tue Jun 13 2000 - 14:02:56 CDT
