>Hey all,
>
>I've got an sql table containing a datetime field yyyy-mm-dd hh:mi:ss.mmm. When I do a query form VFP I get the datetime in format yyyy-mm-dd hh:mi:ss but now I realy need to get the milliseconds too. Is there a way ??
>
>Greetz,
>Hans

SELECT CAST(GETDATE() AS DECIMAL(19,12)) DAYS