Something

mysql  Ver 14.12 Distrib 5.0.22, for -netbsdelf (i386) using  EditLine wrapper

Connection id:          6
Current database:       pin21
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.24
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /tmp/mysql.sock
Uptime:                 1 day 4 hours 37 min 7 sec
Threads: 1  Questions: 894  Slow queries: 0  Opens: 77  Flush tables: 2  Open tables: 8  Queries per second avg: 0.009
--------------


CREATE TABLE `weekcalendar` (
  `event` text,
  `' at line 1
mysql> CREATE TABLE `weekcalendar` (
    ->   `event` text,
    ->   `userid` varchar(255) NOT NULL default '',
    ->   `event_type` varchar(50) default NULL,
    ->   `event_finish` datetime NOT NULL default '0000-00-00 00:00:00',
    ->   `received` datetime NOT NULL default '0000-00-00 00:00:00',
    ->   `price` varchar(200) default NULL,
    ->   `venue` varchar(255) default NULL,
    ->   `title` varchar(255) default NULL,
    ->   `location` text,
    ->   `description` text,
    ->   `id` int(11) NOT NULL auto_increment,
    ->   `flier` text,
    ->   PRIMARY KEY  (`id`)
    -> );
Query OK, 0 rows affected (0.28 sec)

mysql> select *, unix_timestamp(received) as receivedepoch from weekcalendar order by DATE_FORMAT( received,'%w')
    -> ;                                                                                                                                     
Empty set (0.21 sec)                                                                                                                         
mysql>