Question: There is a column in a SQL database (I'm working with SQL-SMT), the data looks like this:

```
Date
1021165435
1021215439
1021215441
1021162126
1021162122
1021212135
1021162137
1021212136
1021213136

```

For the first element, the purpose is to get something like: 21-10-2014 16:54:35 but I can't figure out how to do it, I already checked [this post](https://stackoverflow.com/questions/12186721/convert-four-digit-number-into-hour-format-sql), but they use the '%' function, which according to SQL is incompatible with float and int. I sorted the code in this way:

```
select [Hora origen ] ,
       nHora= convert(time ,
                 right( '0' + convert(varchar, [Hora origen] / 10000 ) , 2 )
               + ':'
               + right( '0' + (([Hora origen]-([Hora origen] % 100))% 10000)/100 , 2 )
               + ':'
               + right( '0' + convert(varchar, [Hora origen] % 10000 ) , 2 ) 
               )
from Trx_tj$;

```

But still, it's not working

Answer: 
A bit late, but here's the answer: [com.google.maps.android.PolyUtil.containsLocation()](http://googlemaps.github.io/android-maps-utils/) from Google Maps Android API utility library.
You can use the Geofencing feature for this purpose. The API's for that are a part of Google Play Services library and hence you can start using it by importing it into your app project. 

It even gives the notification if a particular user has entered or exited a specific geofencing location in order for a developer to monitor the number of mobile devices entered in the zone he defined. The implementation is pretty simple, I am pasting some links that may guide you further.

This is Google's official documentation about Geofencing: 
<http://developer.android.com/training/location/geofencing.html>

This [link](http://java.dzone.com/articles/android-geofencing-google-maps) actually implements an app for geofencing.

And this is another [link](http://www.plotprojects.com/?utm_expid=66248451-11.Cw6ggXUqTpukf9MyY0eJLw.0&utm_referrer=http%3A%2F%2Fwww.google.com%2Faclk%3Fsa%3Dl%26ai%3DCLOpdzbGUVIHVN4KFpQPjn4GQBonhy7YFyemNyr4BkbK4k_kBCAAQAWDJ7u2GyKOgGYgBAaABx9fP3QPIAQGpAqosBt50g7Q-qgQiT9D84gi_3V4SUoXUKWUMXLcau4rYrXPH1AWkr0nJWFjT5IAHoaiwIpAHAagHpr4b%26sig%3DAOD64_3SxjtcFOFpu13YtWb_79OhW2tWgw%26rct%3Dj%26q%3D%26ved%3D0CB4Q0Qw%26adurl%3Dhttp%3A%2F%2Fwww.plotprojects.com%2F) if you want to use a third party plugin in order to get geofencing in your app.

Hope this would help!!!