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)
apple iphone 16 return in UK Glasgow
After I saw that WhatsApp desktop is not working(I tried 2 different laptops, uninstalled or resetting the app but did not work) and uBlock...
-
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 ...
-
if you have wl11 ejb server and in that environment generated ejb client and deploy to wl12 it will give you this exception java.lang.NoSu...
-
yada ben okuduğumdan onu anladım fekat her zamanki gibi aleti kurarken patladı :) MS in express veya beta şeyleri genelde install aşamasında...
No comments:
Post a Comment