RE: Problem with sysdate in SPL

Posted in 2015

Art Kagel — Wed, 04 Nov 2015 18:13:02 — source: IIUG Forums & Mailing Lists

Everett: Because CURRENT will return the exact same time everytime it is called within a transaction. This is by ANSI SQL rules. Art On Nov 4, 2015 10:20, "Everett Mills" <Everett.Mills@nationalbeef.com> wrote: > Why not just use this: > > SELECT CURRENT YEAR TO FRACTION FROM sysmaster:sysdual > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > Paul Watson > > Sent: Tuesday, November 03, 2015 12:15 PM > > To: ids@iiug.org > > Subject: RE: Problem with sysdate in SPL [35989] > > > > As Art suggested write a simple UDR that uses getimeofday, it will be > > trivial > > > > Cheers > > Paul > > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > SERVIO VELASCO > > Sent: Tuesday, November 03, 2015 12:11 PM > > To: ids@iiug.org > > Subject: Re: Problem with sysdate in SPL [35988] > > > > Thanks for yours answers, but DBINFO returns until seconds. > > > > We need fractions of second. Exists any forms to convert or DBINFO > > returns fractions of second. > > > > Thanks a lots > > > > *********************************************************************** > > ***** > > *** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > *********************************************************************** > > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c30f78d8b9fd0523baf5f7