Search results for query: *

Hi All, I just want to know Actuate 5 supports oracle 9i or not. thanks Chethan

Hi all, I need an help how to update a few charcaters in a column using UPDATE statement in SQL Server. thanks :->

Hi All, I am trying to solve the Daylight saving(+1 hour or -1 hour)problem for cisco phones. since the data is stored in unix time (ie in numbers)in SQL Server7(it doesnot support getutcdate() function), I solved the conversion from number to date, but I need to add 1 hour or substract 1 hour...

Hi all If any one has the Idea how to find the first week and last week of the month in SQL Server Thanks in Advance Chethan

Hi, I try to execute the getutcdate() function it dont work...

Frank, Add 3600 to 18000 for Daylight Saving, dont substract 3600 from 18000, since you r on Eastern time. This Unix time converstion sucks...

Frank, r u in Eastern Time Zone or Centeral or Mountain,I am in Eastern Time Zone -5:00 GMT (18000), I dont know how to check the daylight savings (+1 Hour or -1 Hours). I am trying to find out the way how to Implement this daylight saving.

Frank, try this out, this should work, since :Startdate and :Enddate are input parameters I used to pass in Actuate report. SELECT a.callingPartyNumber, a.finalCalledPartyNumber, a.originalCalledPartyNumber...

remove the , before from statement and try

Rob, I am using this query in Actuate to hit the SQL Server to get the report, Its working fine.

Hi All, Please help in fixing the Daylight Saving. Here is my query for Eastern Time. SELECT a.callingPartyNumber, a.finalCalledPartyNumber, a.originalCalledPartyNumber...

Hi Try this out for Eastern Time in US. SELECT a.callingPartyNumber, a.finalCalledPartyNumber, a.originalCalledPartyNumber, dateadd(second,ISNULL((a.dateTimeOrigination-18000),a.dateTimeOrigination),'19700101 00:00:00') as...