Share Pastebin
Guest
Public paste!

Untitled

By: a guest | Feb 9th, 2010 | Syntax: None | Size: 0.30 KB | Hits: 25 | Expires: Never
Copy text to clipboard
  1. mysql> select from_unixtime(1265756056.34017, '%Y %D %M %h:%i:%s.%f') as time;
  2. +-----------------------------------+
  3. | time                              |
  4. +-----------------------------------+
  5. | 2010 9th February 05:54:16.000000 |
  6. +-----------------------------------+
  7. 1 row in set (0.00 sec)
  8.  
  9. mysql>