You want to get the Time Opened from the database and need to know what table Time Opened is on.
The clicktracking_ table stores events like Time Opened. Look for records where the URLID_ field (column) is blank. The field that stores the date/time that the message was opened is the TIMECLICKED_ field. See the table below for details on the fields in the clicktracking_ table.
|ClickID_||An auto-numbering field to provide a unique ID. (int, NOT NULL)|
|GroupID_||The group that this click is associated with. (int, NOT NULL)|
|IPAddress_||The IP address of the user clicking on a link. Stored as an int. (int, NOT NULL)|
|MemberID_||The ID of the member who was sent the email which resulted in this click (int, NOT NULL)|
|MessageID_||The ID from the outmail_ table that represents the mailing that caused this event. (int, NOT NULL) This is seen as MailingID_ in other areas of ListManager. They are the same thing with different names.|
|StreamWebPageName_||The user-provided name of the web page that caused this event. (varchar(255), NULL)|
|TimeClicked_||The time that the click event occurred. (smalldatetime, NOT NULL)|
|UrlID_||The ID from the URLs table that stores this URL. (int, NULL)|