Interval type

hello all,

I finally found out that there is a way to correctly enter a “day to second” - interval into a TOAD data grid (+dd hh24:mi:ss.nnnnnn), but is there a way to change this default format to - lets say - a NUMBER of seconds (or hours)?
Another grid option for intervals like “simple numbers are seconds, days, hours” ?

best regards
Hans Hauer

For displaying (and doing math on) an interval, I finally discovered
the Extract function -
extract(second from
nvl(end_timestamp,sysdate)-begin_timestamp)
+ extract(minute from
nvl(end_timestamp,sysdate)-begin_timestamp)*60
+ extract(hour from
nvl(end_timestamp,sysdate)-begin_timestamp)*3600
+ extract(day from
nvl(end_timestamp,sysdate)-begin_timestamp)360024
But that doesn’t help on data entry.

Nate Schroeder
US Seed & Trait Commercial IT - Data Management Team
Monsanto Company
800 N. Lindbergh Blvd. LC4D - Saint Louis, MO - 63167
314-694-2592

This e-mail message may contain privileged and/or confidential information, and is intended to be received only by persons entitled to receive such information. If you have received this e-mail in error, please notify the sender immediately. Please delete it and all attachments from any servers, hard drives or any other media. Other use of this e-mail by you is strictly prohibited.

All e-mails and attachments sent and received are subject to monitoring, reading and archival by Monsanto, including its subsidiaries. The recipient of this e-mail is solely responsible for checking for the presence of “Viruses” or other “Malware”. Monsanto, along with its subsidiaries, accepts no liability for any damage caused by any such code transmitted by or accompanying this e-mail or any attachment.

The information contained in this email may be subject to the export control laws and regulations of the United States, potentially including but not limited to the Export Administration Regulations (“EAR”) and sanctions regulations issued by the U.S. Department of Treasury, Office of Foreign Asset Controls (“OFAC”). As a recipient of this information you are obligated to comply with all applicable U.S. export laws and regulations.