How to Convert Videos Using Qt and FFmpeg

In this post I’m going to describe how you can use FFmpeg library to convert videos in your Qt applications, or even write a Video Conversion program that uses FFmpeg as its underlying powerful conversion engine.

Unfortunately you can’t use Qt Framework out-of-the-box to convert video files and formats to each other (at least that is the case until the time this post was published, or in other words until Qt5.10.1). One of the most practical workarounds for this missing capability is using 3rd party video conversion libraries and tools such as FFmpeg.

Continue reading “How to Convert Videos Using Qt and FFmpeg”

How to convert date formats in SQLite

Date types are handled like a string in SQLite and below is an example of how to change the date format from MM/dd/yyyy to yyyy-MM-dd. With a little modification it can be used for other formats too.

select substr(column, 7, 4)||”-“||substr(column, 1,2)||”-“||substr(column, 4,2) from table