The generation of ultra-narrowband, pure and storable single photons with widely tunable wave shape is an enabling step toward hybrid quantum networks requiring interconnection of remote disparate quantum systems. It allows interaction of quantum light with several material systems, including photonic quantum memories, single trapped ions and opto-mechanical systems. Previous approaches have offered a limited tuning range of the photon duration of at most one order of magnitude. Here we report on a heralded single photon source with controllable emission time based on a cold atomic ensemble, which can generate photons with temporal durations varying over three orders of magnitude up to 10 μs without a significant change of the readout efficiency. We prove the nonclassicality of the emitted photons, show that they are emitted in a pure state, and demonstrate that ultra-long photons with nonstandard wave shape can be generated, which are ideally suited for several quantum information tasks.