Are you just forgetting to add GROUP BY … at the end? SELECT COUNT(id) as order_count, SUM(price + shipping_price) as order_sum, DAY(FROM_UNIXTIME(created)) as order_day FROM `order` WHERE ‘.implode(‘ AND ‘, $where).’ GROUP BY order_day NOTE: You cannot use as day for your day column because day is a MySQL function. Use something like order_day. Of … Read more
I think what you need is touch command if you are on unix operating system. Git can however allow you to do a empty commit if you use –allow-empty option. Eg. $ git commit –allow-empty -m “Trigger notification” would cause an empty commit which you can then push and do another deploy.
Calling toInstant().toEpochMilli(), as suggested by @JB Nizet’s comment, is the right answer, but there’s a little and tricky detail about using local dates that you must be aware of. But before that, some other minor details: Instead of ZoneId.of(“GMT”) you can use the built-in constant ZoneOffset.UTC. They’re equivalent, but there’s no need to create extra … Read more
You can validate if a string is a valid timestamp like this: var valid = (new Date(timestamp)).getTime() > 0; var valid = (new Date(‘2012-08-09’)).getTime() > 0; // true var valid = (new Date(‘abc’)).getTime() > 0; // false Revisiting this answer after many years, validating dates can still be challenging. However, some of the argument is … Read more
Because Javascript uses milliseconds internally, while normal UNIX timestamps are usually in seconds.
That is expected and documented behaviour: From the manual: Since these functions return the start time of the current transaction, their values do not change during the transaction. This is considered a feature: the intent is to allow a single transaction to have a consistent notion of the “current” time, so that multiple modifications within … Read more
You may simply use %3N to truncate the nanoseconds to the 3 most significant digits: $ date +”%Y-%m-%d %H:%M:%S,%3N” 2014-01-08 16:00:12,746 or $ date +”%F %T,%3N” 2014-01-08 16:00:12,746 testet with »GNU bash, Version 4.2.25(1)-release (i686-pc-linux-gnu)« But be aware, that %N may not implemented depending on your target system or bash version. Tested on an embedded … Read more