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.
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??? Hmmm...
solved