Joe Murithi Njeru

Tag: Convert

  • Convert string from dd/mm/yyyy to yyyy-mm-dd using mysql

    I had a large dataset with all the date fields in the format DD/MM/YYYY. I needed to convert them to YYYY-MM-DD . I ran the following queries: UPDATE TABLE_NAME SET FIELD_NAME = replace(FIELD_NAME, ‘/’, ‘-‘); UPDATE TABLE_NAME SET FIELD_NAME = str_to_date(FIELD_NAME,’%d-%m-%Y’); Hope it helps…

  • Convert all FLV’s in a directory to Ogg Theora (video)

    I just submitted the following to commandlinefu : Do you have a large library of flv’s you have picked up over the years using FlashGot Firefox plugin? Do you want to be able to convert them to Ogg Theora (video) at once? Try out this script… for i in $(ls *.flv); do ffmpeg2theora -v 6…