Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
theniker
Starting Member
1 Post |
 Posted - 2002-03-27 : 03:24:50
|
| Hi,The problem is I need to calculate with timeperiod within a oracle db. I have the fields starttime and endtime, both contain a date and time. I want to know what the time is between the starttime and the endtime. If anyone knows what to do plz post itgreetz, nike |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-03-27 : 03:32:22
|
Nike sorry to say we dont deal with Oracle , you could be better off using Sql server apart from the advantages you get from using Sql Server you also get a site like Sqlteam which will support you  .Having said that , try usint To_char funcion in Oracle(its been ages i have used the product, cant remember much)-------------------------------------------------------------- |
 |
|
|
|
|
|
calculating with dates