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@xxxxxxx> wrote: > 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. > > -- //www.freelists.org/webpage/oracle-l