mysql_udf_unix_timestamp_ms
===========================

Implementation of UNIX_TIMESTAMP() that returns UNIX time since epoch with 
sub-second precision (float).

  mysql> select unix_timestamp_ms() * 1000 / 1000;
  +-----------------------------------+
  | unix_timestamp_ms() * 1000 / 1000 |
  +-----------------------------------+
  |                   1276753745.7377 |
  +-----------------------------------+
  1 row in set (0.00 sec)


Installation
------------

 1. Build and install extension library, see, for example: http://dev.mysql.com/doc/refman/5.0/en/udf-compiling.html
    a) Mac OS X with MacPorts:
        #!/bin/sh

        gcc -bundle -bundle_loader /opt/local/libexec/mysqld -o lib_udf_unix_timestamp_ms.so lib_udf_unix_timestamp_ms.c -I/opt/local/include/mysql5/mysql
        sudo cp lib_udf_unix_timestamp_ms.so /opt/local/lib/mysql5/mysql/plugin/

    b) Linux (CentOS)

        get lib_udf_unix_timestamp_ms.{c,sql}
        gcc -shared -fPIC -o lib_udf_unix_timestamp_ms.so lib_udf_unix_timestamp_ms.c -I /usr/include/mysql/
        su
        cp lib_udf_unix_timestamp_ms.so /usr/lib
        /sbin/ldconfig

 2. Install function into MySQL:
    mysql mysql < lib_udf_unix_timestamp_ms.sql

License
-------

You're free to use, distribute and modify this code. It is public domain.