Find time zone by lat/lon

Custom SQL query returning 1 row (hide)

select tzid
from
  timezones
where
  within(
    MakePoint(cast(:longitude as float), cast(:latitude as float)),
    timezones.Geometry
  ) = 1
  and rowid in (
    select
      rowid
    from
      SpatialIndex
    where
      f_table_name = 'timezones'
      and search_frame = MakePoint(cast(:longitude as float), cast(:latitude as float))
  )

Query parameters

longitude

latitude