What model Sony Cybershot do you have? Every one I’ve ever used can take unlimited video, but you have to do it on a lower resolution and you have to hold down the shutter button the whole time.
You’re thread is titled “video camera” - are you talking about buying a camcorder or another camera that can do video?