Sorry, forgot to mention that column is number(4), so no date functions allowed.

e.g.

TIME_AT_ADDRESS number(4)

Code:
Data in   Data Loaded
-------   -----------

0311      47
0106      18
9999      9999