Re: CURRENT date precision

Kevin DeWitt wrote: > I'm using a DATE YEAR TO FRACTION(3) field as a key in a table. I'm not > getting the precision I expect in the following statement: > > LET var = CURRENT YEAR TO FRACTION(3); > > My var variable ends up with a precision to seconds only. No milliseconds! > Any ideas how to get my milliseconds? Firstly check your release notes. Not all platforms support sub-second precision. If yours does, then set the configuration parameter USEOSTIME=1 in your configuration file. Hope that helps, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+