Analytics Software

Hi ,

I want to be able to perform this funtion. I'm writing a sql code for a crystal report. I have a timestamp field which is in UTC time. And I have a start/end date field in Pacific time. Also I have a function where we have the logic to find the offset between a UTC time and eastern time.

So basically what I want to achieve is Timestamp field= start/end date + offset funtion.//so this would give me the eastern time although I enter start/end date in pacific time.

since teh start/end date is in date format and offset is in number format I'm not able to perform this addition. What functions do I use to my start/end date field so that I can add it up to my offset funtion (which is in number format) ??

Please help.

Thanks