At 12:46 PM 10/17/2002 -0400, you wrote:
Wat would be the best way to find the difference between two DATETIME variables in Rbase 6.5++?Dear Steve;
I need to be able to take the difference of those two variables and break the difference down to a total of seconds.
SET VAR v1 DATETIME = '08/09/95 12:15:30.123'
SET VAR v2 DATETIME = '09/19/95 13:15:30.123'
SET VAR v3 INTEGER = ((TEXTRACT(.v2)) - (TEXTRACT(.v1)))
This will return a value of 3600 in variable v3. This is your difference in seconds.
You can expand things further by using the RTIME function to change it into
hours, minutes and seconds.
Best Regards,
Mike
-------------------------------------------
Michael Willochell
Director, Customer Support
R:BASE Technologies, Inc.
3935 Old William Penn Highway
Murrysville, PA 15668-1854
Phone: 724-733-0053
FAX: 724-733-0196
URL: www.rbase.com
Sales: [EMAIL PROTECTED]
Support: [EMAIL PROTECTED]
-------------------------------------------
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
