Friday 31 July 2020

PHP: How to get todays date in ISO format compatible with MySQL [answered]

PHP: How to get todays date in ISO format compatible with MySQL [answered]


I often write reports that use date format for selection and need to query a database. I use PHP, so here's the way I get dates.

$dateToday date("Y-m-d");   // 2020-07-31 (iso format can be used in MySQL)

$dateTimeNow date("Y-m-d H:i:s"); // 2020-07-31 08:35:18 (the MySQL DATETIME format)  

I hope this is useful to you.
If you found it useful, perhaps have a listen to my music at Projektor Digital https://app.projektordigital.com/player/index.php?playlist=39&uid=7

Wednesday 8 July 2020

How much is 1 billion pounds [answered]

In a recent broadcast, by chancellor Rishi Sunak, a sum of 3 billion pounds for a green jobs plan was mentioned.

How much is a billion pounds? Google doesn't help by mentioning million pounds in search results.

So in 2020, how much is 1 billion pounds?

1 Billion is now accepted as 1,000 million pounds. As a number 1 billion is 1,000,000,000.
So 1 billion pounds is £1,000,000,000.

In context this is the cost of 40 streets in the UK.

There are 66.65 million people in the UK

Search Results

United Kingdom/Population
66.65
So that means that £1bn is £15 per person in the UK

One billion pounds is approximately £15 per person in UK