Field Service - EBS (MOSC)

MOSC Banner

Adding hours to dates fails in MFS (customization)

edited Jun 12, 2013 10:28PM in Field Service - EBS (MOSC) 2 commentsAnswered
Hi guys,

We have a customized Service Request report in MFS. That report needs to take into account the timezone offset.
So I'm using a query with something like:

to_char(l.labor_start_date+" + time_offset +"/24,'DD-MM-YYYY HH24:MI:SS')

where time_offset is a variable which is calculated seperately. The table "l" is csm_debrief_labor
This works perfectly when time_offset is a negative value, but fails miserably when time_offset is a positive value.

I changed the code into: to_char(l.labor_start_date+1/24,'DD-MM-YYYY HH24:MI:SS') but that doesn't work
to_char(l.labor_start_date-1/24,'DD-MM-YYYY HH24:MI:SS')

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center