Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: date minus one
Well, I would normally use perl, but this was a ready
made off the shelf solution.
No point writing code when you have something that fits the bill.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist On Mar 29, 2005 6:01 PM, Graeme St. Clair <Graeme.St.Clair_at_hds.com> wrote:Received on Wed Mar 30 2005 - 13:32:12 CST
> Why wouldn't you just use Perl "time() - 86400" (# seconds in a day), and
> then transform as desired with gmtime or whatever? (In theory it might be a
> second off if you did it at half a second past a midnight with a leap
> second...)
>
> Rgds, GStC.
>
>
-- http://www.freelists.org/webpage/oracle-l