SQLite and dates

[Taifun]

To get leading zeros for 1 digit months and days you could use this procedure

How to force added zero to format as decimal

as you can see from the example screenshot, the procedure works for 1 digit numbers, however for number with decimals you have to adjust it to your needs... [2leadingZeros] The example uses the exponential operation, see also Exponents The exponent of a number says how many times to use the number in a multiplication. example number=7, digits=4: 104+7=10007, now remove the first digit to get the result, which is 0007 example number=123, digits=4: 104+123=10123, now remove the first digi…

Taifun