I want a query for getting difference in timings of two coloumns..
my query is getting time in the format hhmm(1417) for 02:17 pm..
i want a function which can calculate the time difference..for an example
for create time is 1842 and close time is 1912 the difference sholud come 30 mins........
Help me!!!!!!!!!!!