SQL Server Performance

timestamp

Discussion in 'Getting Started' started by vinodpurbia, Jun 2, 2007.

  1. vinodpurbia New Member

    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 .
  2. alzdba Member

    convert(datetime, '2003-12-31 22:45:00',120)
  3. vinodpurbia New Member

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

    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
  5. FrankKalis Moderator

    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

Share This Page