May I ask about the timestamp?

I would like to ask you how the selected time period becomes a timestamp. I would like to compare it with the one in the table.

clipboard.png


clipboard.png
as shown in the figure, first see how to change a string date into a time stamp
time period, just change both ends.

you mentioned that if you want to compare with the table, you need to pay attention to

.
  • you're talking about a data table, not an EXCEL table.
  • pay attention to the time zone. The timestamp obtained by this method is 0: 00 Beijing time, that is, 16:00 the day before GMT. You need to be consistent with the time zone in the table.

The

timestamp refers to the total number of seconds since 00:00:00 GMT on January 1, 1970 (08:00:00 on January 1, 1970, Beijing time).
means that the timestamp is the number of seconds at a point in time (calculated from 00:00:00 on January 1, 1970).
you can look up the timestamp at a point in time from this site-> timestamp conversion

js converts the time stamp
var timestamp = (new Date ()). GetTime ();

for example, 2018-10-09 timestamp is 1539014400
2018-10-12 timestamp is 1539273600

the timestamp of the data to be queried is time > 1539014400 and time < 1539273600

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1eae132-46eea.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1eae132-46eea.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?