Sort by date in ascending order, and the date field must be greater than 0 in the timestamp format. Sort by ascending order, and the date must be greater than zero. I don't know how to implement the program? It is better to use a simple method. thank you ., SQLcode... WHERE 'Date' & gt; 0ORDERBY 'date' ASC, select uses the ascending date order, and the date must be greater than 0
The date field uses the timestamp format and is sorted in ascending order. The date must be greater than zero. I don't know how to implement the program? It is better to use a simple method. thank you.
------ Solution --------------------
SQL code
... WHERE 'Date'> 0 order by 'date' ASC
------ Solution --------------------
Select * from t where 'time'> 0 order by 'time' asc;
------ Solution --------------------
The timestamp is equal to 0.
It indicates the time 00:00:00 on January 1 ,.
The former is negative, and the latter is positive.
Isn't it true that "all those whose dates are 0 will be filtered out?
Didn't you ask "to sort by ascending order, and the date must be greater than zero?
Is there any special meaning that this zero is not 0?