var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DATETIME to INTEGER
i have a timestamp in the sysmaster Table.
connected is a INTEGER (timestamp like 1323872928).
SELECT connected FROM sysmaster:syssessions;
How i can convert it to a Datetime? Because i need a WHERE with CURRENT.
Sorry for my english
SELECT connected FROM sysmaster:syssessions WHERE connected = is older then one day
That "timestamp" is a unix timestamp format. Do this:
SELECT DBINFO('utc_to_datetime',connected ) FROM ...
Daylight savings time can possibly make a difference... not sure.