IDS systems create a stored procedure called 12date (the first character is a lower-case "L") which will calculate the date only. If you want to get the date in datetime format, run the following SQL statement:
SELECT sid,username,hostname,connected, DATETIME(1970-01-01 00:00:00) YEAR TO SECOND + connected UNITS SECOND FROM sysmaster:syssessions;
This gives you the date and time in GMT (Universal Time) for the connection.