UNDO a SQL Query

[phreaqo]

Is there any way to undo a query without manually backing up the db before executing the query?
I accidentally performed a date conversion which ruined all of my dates in the db and I need to get those orignal dates back. Any help on retrieving that information is greatly appreciated.

Thanks,
Phreaqo

 

[melone]

Can you exit without saving?

 

[phreaqo]

Nope, the changes have already been made to the database.

 

[xwb]

There is something called setpoints and rollbacks but whether or not they exist in your database is something else.

Is there an old backup you can use?

 

[CajunCenturion]

Depending on the nature of the original query, and what type of conversion took place, you may be able to run another query which reverses the effect.

What was the SQL statement of the original query?

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein