We are using REMEDY for call tracking at our help desk and it writes timestamps equal to the number of seconds that have passed since 1 Jan 1970. Is there someway to identify this date format to BO. I want to be able to schedule reports based on real dates (i.e. dd/mm/yyyy or FEB 1997) and not have to identify the total number of seconds since 1JAN70.
Listserv Archives (BOB member since 2002-06-25)
If you are using Oracle, you could define an object as:
TO_DATE( ‘01/01/1970’,‘MM/DD/YYYY’ ) +
( NUM_SECS / 86400 )
86,400 = 60 * 60 * 24, the number of seconds in a day.
Of course this means you can’t use any indexes you may have on NUM_SECS.
Erich Hurst
Compaq Computer Corporation
Listserv Archives (BOB member since 2002-06-25)
In a message dated 98-09-14 13:32:43 EDT, you write:
We are using REMEDY for call tracking at our help desk and it writes
timestamps equal to the number of seconds that have passed since 1 Jan 1970. Is there someway to identify this date format to BO.
I would imagine that you will have to do this with logic in your objects. Since a date format to BusObj is expected to be a date value, you will need to translate your Remedy dates into some sort of standard dates.
What is your back-end database? There are various conversion functions available depending on what RDBMS vendor you are using.
You may also want to consider carefully how your query conditions are going to be written. If you have to use a conversion function, you would like to have the conversion done on the criteria rather than the database column (assuming indexes exist).
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)
MSSQL 6.5 is our RDBMS.
In a message dated 98-09-14 13:32:43 EDT, you write:
We are using REMEDY for call tracking at our help desk and it writes
timestamps equal to the number of seconds that have passed since 1
Jan
1970. Is there someway to identify this date format to BO.
I would imagine that you will have to do this with logic in your objects.
Since a date format to BusObj is expected to be a date value, you will need to
translate your Remedy dates into some sort of standard dates.
What is your back-end database? There are various conversion functions available depending on what RDBMS vendor you are using.
You may also want to consider carefully how your query conditions are going to
be written. If you have to use a conversion function, you would like to have
the conversion done on the criteria rather than the database column (assuming
indexes exist).
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
For old 3.1 info:
Penn: Page not found
Search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
Listserv Archives (BOB member since 2002-06-25)