But unix timestamp doesn't support milliseconds either. You could
store the timestamp in one column and the milliseconds in an extra
smallint column. Then combine the two on output.
-Eric
On Thu, 24 Jun 2004 12:25:19 +0200, Gianpaolo Fasoli
<gianpaolo.fasoli@stripped> wrote:
>
> Hi,
>
> We are looking into migrating our application from oracle to mysql.
>
> Almost every migration issue we've hit could be solved except for this one.
>
> In one of our oracle tables, we've got a column with a timestamp datatype.
>
> select * from (select to_char(ts_action, 'MM/DD/YYYY HH24:MI:SS.FF3')
> from table1) where rownum <= 2;
> TO_CHAR(TS_OPERATION,'MM/DD/Y
> -----------------------------
> 06/01/2004 18:57:05.406
> 06/01/2004 18:57:05.828
>
> The problem here is that I have to be able to store milliseconds in a
> mysql table. From what I've read in the manual MySQL does not support
> milliseconds in any of the date datatypes.
>
> The only alternative I see, would be to extract the date in a
> unix_timestamp like format from oracle and insert it into an INT. This
> of course means the application would have to handle date conversion for
> output to user.
>
> Is this the only solution I have or did I miss something?
>
> Thanks in advance,
>
> GP.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
