Well, apart from the timezone that would in DATE_FORMAT syntax equal:

%W %d %M %Y @ %I:%i%p

If you're willing to be a bit database-specific, use UNIX_TIMESTAMP to get the timestamp in epoch-format and then use POSIX::strftime to format your date.

# epoch-date in $epoch
use POSIX;
my $formatted_date = 
  POSIX::strftime("%A %d %B %Y @ %I:%M%p %Z",localtime($epoch));
[download]

If you want to be as non db-specific as possible, take the advice below and forget UNIX_TIMESTAMP. Just select the timestamp-column and use appropriate date-manipulation module to convert it to epoch-format.