Time Difference

[mtownbound]

CR9
Oracle 9i
Windows 2K


The server running CR is EST, but I need to accomate the GMT on our database server which is a 4 hour difference. I looked but couldn't find too much on this in the forums. I've been trying variations of cdatetime and datediff, but to no avail. Can't just change the local server time either because I need to publish several of these over the next few weeks. Any ideas??


Thanks!!!

 

[Turkbear]

Hi,
By
"but I need to accomate the GMT on our database server"

do you mean that the Database server's time is GMT, or that you want the reports to use GMT when showing the Time?
( The DateDiff functions should do what you need, in that case - what issues are you having using them?)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[mtownbound]

Sorry about that.....yeah the database server is GMT

I need to run a report on the database, but the local server is using the local time instead of GMT.

 

[mtownbound]

More amplifying info:

I want to run a LastFullMonth report but the report is missing records because of the 4hour time difference. Any workarounds?