We (for reasons not worth getting into) have all our data stored in a 30hr clock that 'starts' at 06:00 and ends at 30:00 (or rather 29:59, which would be 05:59 obviously). The main developers here always seem to busy to give my table view the integer type stored time, which is in seconds, thus easily converted - so I wanted to see if in my query I could just throw it a few functions in the SELECT statement to return a proper timestamp or double-point value for use in Excel/Access later on?
I tried variations of "SELECT TO_TIMESTAMP(MOD(START_TIME,2400),'HH:MI:SS') FROM..." but to no avail. I just seem to be confusing it.
Anyone know a way around this?
- Moved by Mike YinMicrosoft contingent staff Monday, February 03, 2014 2:43 AM off-topic