Decrementing a datetime field in Paradox

This article has not been rated yet. After reading, feel free to leave comments and rate it.

There is a bug in Local SQL on Paradox:
Executing an Update statement on a Paradox table where '1' is being subtracted in a datetime field does not subtract '1', but rather adds '1'.

	// this will ADD one! UPDATE SAMPLE.DB SET DT = DT - 1 // the following workaround will give the correct result: UPDATE SAMPLE.DB SET DT = DT + (-1)

Comments:

NEW: Optional: Register   Login Email address (not necessary): Rate as Off-topic Very Helpful Helpful Ok article Not useful Very bad	Hide my email when showing my comment. Please notify me once a day about new comments on this topic. Please provide a valid email address if you select this option, or post under a registered account.
	Show city and country Show country only Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:
Add a picture: Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material.