IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Brief testing says this might be correct.
Post #167,550
by admin
Picture of admin
8/5/04 12:01:23 AM
Reply
New Brief testing says this might be correct.
select to_char(sysdate - sysdate, '.99999999999999') from dual; was 0 all the way out.

Also:
SQL> select cast(sysdate as timestamp),cast(sysdate as timestamp) from dual;\n\nCAST(SYSDATEASTIMESTAMP)\n---------------------------------------------------------------------------\nCAST(SYSDATEASTIMESTAMP)\n---------------------------------------------------------------------------\n05-AUG-04 12.00.51.000000 AM\n05-AUG-04 12.00.51.000000 AM


Not exactly a rigorous test, but...

I do believe that multiple calls to sysdate in a pl/sql function will return different values, however. It's certainly a performance drag.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
Post #167,554
by ChrisR
8/5/04 12:35:23 AM
Reply
New FWIW
SQL 2000 doesn't allow you to call GETDATE() from within functions for that reason (which can be a real PITA when that's what you actually need to do).

I'd assume that functions are sequential, not atomic, in nature, so you would be faced with SYSDATE varying through a function called within a query.
     risky use of Oracle SYSDATE? - (tablizer) - (11) - Aug. 4, 2004, 07:45:50 PM EDT
         Hmm. Order of evaluation - (broomberg) - Aug. 4, 2004, 08:15:43 PM EDT
         If only the date matters... - (admin) - (5) - Aug. 4, 2004, 09:31:53 PM EDT
             Still could cross over -NT - (broomberg) - (4) - Aug. 4, 2004, 10:27:10 PM EDT
                 Unless you change the logic - (admin) - (3) - Aug. 4, 2004, 11:10:14 PM EDT
                     sysdate wrapper - nice touch - (broomberg) - (1) - Aug. 5, 2004, 12:03:50 AM EDT
                         Guideline doc for DML wrappers: - (admin) - Aug. 5, 2004, 12:06:53 AM EDT
                     Re: Unless you change the logic - (tablizer) - Aug. 7, 2004, 05:14:31 AM EDT
         Another thought - (admin) - Aug. 4, 2004, 11:25:22 PM EDT
         It would surprise me if the SYSDATE wasn't in a closure - (ChrisR) - (2) - Aug. 4, 2004, 11:39:40 PM EDT
             Brief testing says this might be correct. - (admin) - (1) - Aug. 5, 2004, 12:01:23 AM EDT
                 FWIW - (ChrisR) - Aug. 5, 2004, 12:35:23 AM EDT

He is very comfortable with his feet.
60 ms