,num(SubField(text(GPS_LATITUDE),':',3))/3600) as NEW_LAT,
,num(SubField(text(GPS_LONGITUDE),':',3))/3600) as NEW_LON, as if there are nulls the + operator doesn't work i think,
but is there any other way of doing this like when we read date we use DATE# then convert it using DATE in desired format , do we have similar thing for coordinates or can we use some existing functions to do so?
I'm not sure if this can be done with date() funtions, in that functions the base unit is the day, in this operation base unit is the hour, I think that using dates will also need maths operations to convert to the desired result.
Also, using time functions will cause the seconds to round, losing the decimals and moving the point... or maybe with timestamp... in any case, those are also day based funtions.... maybe with "Interval(DateField)*24"?