precision in the date/time field 
Author Message
 precision in the date/time field


>Thank you for the advice.   I still cannot get the decimal part printed
>correctly, though, even when I change USEOSTIME from 0 to 1.

Did you recycle the instance?


> > Try to set USEOSTIME=1 in onconfig.

> > Good luck!.

> > Sergey.

> > > When I do 'select current' I always get .000 in the decimal part of
> > > time field (11:35:18.000).   How can I get the exact time, for
> > > 11:35:18.133

> > > Thank you!

> > > Sent via http://www.***.com/
> > > Before you buy.

>Sent via http://www.***.com/
>Before you buy.

Get Your Private, Free E-mail from MSN Hotmail at http://www.***.com/ .

Share information about yourself, create your own public profile at
http://www.***.com/ .

Wed, 18 Jun 1902 08:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. precision in the date/time field

2. ADO with Access Date/Time field not storing the time, just the date

3. how to change dates or times in a oracle date time field

4. Query datetime-field by date when field contains date + time

5. date/time precision from SQL to Excel

6. Date/time precision in 7.2

7. Can't read time from Access 2000 date/time field

8. Extract Date only from Date/Time Field

9. Comparing datetime field (containing date, time values) to a date only string

10. Getting the date value of a date/time field

11. How to retrieve only the Date from date time field

12. Null date values in Date/Time fields in Access DB

Powered by phpBB® Forum Software