just select dates is easy like this
SELECT FROM_UNIXTIME( revtstmp/1000 ) FROM revinfo;
if you want the detailed data result you can do like this.
SELECT r.rev,FROM_UNIXTIME( revtstmp/1000 ),pa.* FROM revinfo r
left join picture_aud pa on pa.rev=r.rev;
well you just need to change table name up there picture to what ever is your table name is.
Subscribe to:
Post Comments (Atom)
odd string diff
https://leetcode.com/problems/odd-string-difference/ Beats 19.92% of users with Java class Solution { public String oddString ( S...
-
bu durum sessionun uzun ömürlü olmasını istediğinizde yapacağınız bişeydir ki Session["eblek"]="gobalak"; dediğimizde ve...
-
Yeni nesil hacker'lar: Edwin Pena | Olympos Security koptum okuyunca yazılımcılar ve pazarlamacılar bu kadar kısa ve özlü bir hikayeyle ...
-
at the end of any product there will be a reporting interfaces for counts. let say you build a advertisement site which gives people to publ...
No comments:
Post a Comment