If you're looking for a DATETIME() from SQL Server with out the miliseconds portion (pretty handy for proper data sychronization):

(SUBSTRING(CONVERT(char(26),GETDATE(),109),1,20) + RIGHT(CONVERT(char(26),GETDATE(),109),2))

Returns a properly formatted string representation of the date. Either do another CONVERT or process it with VFP


Good Luck