use java.util.Timestamp instead of Date that will solve your problem.

Sarathy

>
>Hellu,
>
>I retrieve a datetime  field from the Ms SQL server. With a win sql client 
>I
>see:
>2001-10-03 19:33:10.257
>
>When I print the field in an EJB (I use CMP) the millisecond part is zero
>!!!:
>Wed Oct 03 19:33:10 GMT+02:00 2001
>In milliseconds: 1002130390000
>
>I had the same problem with the Postgres driver so I don't think it is the
>JDBC driver (Opta driver of i-net)
>
>Has anyone any idea what is happening and how I can solve this ??
>Hope to get an answer, otherwise I have to convert the datetime fields in
>the database to a long to store it in milliseconds, which isn't very 
>elegant
>I think !?
>
>Eddie
>
>
>
>
>


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


Reply via email to