Posted by Ivor Evans on November 07, 2000 at 3:34 AM
thankyou very much indeed Kishori you are an absolute star!!!
> Hi > You are making a very simple mistake. In your date format you are saying hh:mm:ss:SSS, see the colon ( : ) used just before milli second part ( SSS ) , but you are syaing you get > "2000-10-27 12:00:00.000" which uses a period ( . ) just after milli second part ( see the last period ). So just set the date format as yyyy-MM-dd hh:mm:ss.SSS and it will work.