How to convert date formats in SQLite

Posted Leave a commentPosted in Tutorials

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

Shell Overlay Icons Problem Fix

Posted Leave a commentPosted in Tutorials

Having many programs with Shell Overlay Icons in Windows will cause some of them to not appear. This is because there is a limit to how many Shell Overlay Icons. (Not sure but I think it’s around 10 icons) Below is an example of a Shell Overlay Icon. To overcome this problem you need to […]