DATETIME to INTEGER

Socke · #1 (**permalink**) 12-14-11, 09:36

Hi,
i have a timestamp in the sysmaster Table.

Code:

 SELECT connected FROM sysmaster:syssessions;

connected is a INTEGER (timestamp like 1323872928).

How i can convert it to a Datetime? Because i need a WHERE with CURRENT.

Like

Code:

SELECT connected FROM sysmaster:syssessions WHERE connected = is older then one day

Sorry for my english

domusonline · #2 (**permalink**) 12-14-11, 20:33

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.
Regards

Socke · #3 (**permalink**) 12-15-11, 03:07

It works !!!

Big thanks.

Internet Services

Web Development

Digital Marketing

Consumer Tech