SQL Server Performance Forum – Threads Archive

timestamp

equivalent of flashback database/table to timestamp<br /> to_timestamp (’12/31/2003 22:45:00,’mm/dd/yyyy hh24:mi<img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />s’);<br /> in sql server .

---

convert(datetime, ‘2003-12-31 22:45:00’,120)

---

no, actually i want to undo after updating a table using timestamp.can u tell me

---

Where do you want to show data?
If you use front end application,use format function there
Or read about convert function in sql server help file Madhivanan Failing to plan is Planning to fail

---

I’m not entirely sure as I don’t know Oracle that much. However I think he is asking how he can roll back to a previous state before issuing some UPDATE statement. If so, then SQL Server is a bit different from Oracle. There is no built-in support for such roll-back. One way would be to restore the db to that given point in time before the UPDATE was issued. However, in most cases this cannot be done as all modification since then will be lost. Probably the best bet, would be to use a third-party tool such as ApexSQL Log that can undo data modifications via incidental UPDATE statements. —
Frank Kalis
Microsoft SQL Server MVP
Contributing Editor, Writer & Forum Moderatorhttp://www.sql-server-performance.com
Webmaster:http://www.insidesql.de

---

]]>