Google Video Sitemap requires duration in sec

September 13, 2010 at 07:30:35
Specs: Windows XP
Hello all,

I am creating a video sitemap based on the sitemap 0.9 and one of the requirements google has is to convert durations hh:mm:ss or more in my case mm:ss to ss.
No non numbers allowed, so my video with a duration of 11:06 would become 666 seconds.
The generator script is written in perl, which creates/writes out the sitemap in xml.

Anyone with any ideas of how to include a snippet into my script which will convert mm:ss to seconds, what it might look like, and any sample, example, working code would be greatly appreciated.

See More: Google Video Sitemap requires duration in sec

Report •

September 13, 2010 at 08:28:34
substr(length,1,instr(length,':') - 1) * 60 + substr(length,instr(length,':')+ 1)overallseconds gives me the duration in seconds. Where i am querrying the oracle, requesting v.length (video length) in mm:ss is where this needs to go???


Report •

September 14, 2010 at 08:48:41

Report •
Related Solutions

Ask Question