Re: UNIX timestamp with microseconds

2005-11-16 Thread Gleb Paharenko
e-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 : > > 1131

UNIX timestamp with microseconds

2005-11-16 Thread Ryan Escarez
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! -- MySQL General Mailing List For list archives: http:/