Tag Archive: Convert

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

Author: joe February 16, 2011 1 Comment

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 =…
Read more

MySQL

Convert, Date, Formats, mysql, Tip

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

Author: joe December 1, 2010 0 Comments

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)…
Read more

Linux, Video

Convert, Flv, Ogg Theora, Video