Creating sql view that includes sent time and date of the campaign

Summary:

Hello,

We would like to create an sql view in Responsys. In this sql view, we want to see when a specific campaign was sent to the user.
We need it as a time and date.

Is it possible to put this information in the sql view?
If it is possible, how can we show the date and time?

I need to know in which table and under which field the sent date and time are stored.

Thank you in advance!

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):