I'm working with an SQL database that stores dates in integer fields.

I'm using Coldfusion and was wondering if there is a function to convert these
integers into date/times. I've tried things like:

dateadd('hh',-8,#dateadd('s',arrival_time,'1/1/1970')#) with variations such
as -7, -5, etc instead of -8 (I need PST)

and it works alright but the time is way off. Seems like if the hour goes
past 1200 hours things get really strange with the time (i.e. hours are added
or rolled back to midnight then adds a day).

I'm comparing this output with the GUI interface for the product I'm using.

Any ideas? Maybe I need to launch a JavaScript? Seems to me that
Dreamweaver/Coldfusion would have a function for this.

Thank you in advance!