I have three columns in an sqlite table: Column1 Column2 Column3 A 1 1 A 1 2 A 12 2 C 13 2 B 11 2 I need to select Column1-Column2-Column3 (e.g. A-01-0001). I want to pad each column with a – I am a beginner with regards to SQLite, any help would be appreciated … Read more
I’ve created this script to calculate the date for 10 days in advance in the format of dd/mm/yyyy: var MyDate = new Date(); var MyDateString = new Date(); MyDate.setDate(MyDate.getDate()+10); MyDateString = MyDate.getDate() + “https://stackoverflow.com/” + (MyDate.getMonth()+1) + “https://stackoverflow.com/” + MyDate.getFullYear(); I need to have the date appear with leading zeroes on the day and month … Read more
