Hello.
According to the manual "Unix timestamp (seconds since '1970-01-01 00:00:00'", so, in my opinion UNIX_TIMESTAMP is not designed for obtaining microseconds. Have a look here, if you haven't done this yet: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html Ryan Escarez wrote: > is possible to get UNIX timestamp with microseconds > > when i try the following it just give 10 digits > > mysql>SELECT unix_timestamp('20051114095641'+ INTERVAL 0 HOUR) as ts; > > output : > > 1131933401 <--- 10 digits > > any tips? > > tia! > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
