Extracting timestamp from a .mpeg file

[vole324]

Hi!

I have a Sony Handycam DCR-SX80 recorder. We need to extract the exact time when the videos were recorder (hh:mm: ss) form the mpeg file. An ideal situation would be one where we get an .xsl output with the video frames in one column and the specific timestamp for that frame on the following column.

We have already deleted the videos from the camera so there is no possibility of extracting them with a specific software, although if there was a way of doing that I could implement it for my future videos.

I don't need the timestamp to appear as subtitles in the video at all, which is what I've been reading about around here and is not entirely helpful for my case.

I would really appreciate some sort of guidance or help,

Thanks!!

[pandy]

AFAIK there is no standardized timestamps in MPEG file - DTS and PTS are timestamps present in MPEG but they are relative and usually not linked to any real time (clock time).
If there is any timestamps then they are non standard and as such proprietary extension to standard. If this is MPEG Transport Stream then time is stored in TOT/TDT.
http://dvbsnoop.sourceforge.net/examples/example-tot_tdt.html
http://www.dtvmonitor.com/en/tdt
http://www.dtvmonitor.com/en/tot