Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2011
    Posts
    7

    Unanswered: DATETIME to INTEGER

    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

  2. #2
    Join Date
    Nov 2010
    Posts
    16
    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

  3. #3
    Join Date
    Dec 2011
    Posts
    7
    It works !!!

    Big thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •