Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Location
    Brazil
    Posts
    56

    Red face Unanswered: DateDiff Trivial Problem

    Hy Friends,

    I'm having a new annoying problem wiht T-SQL.

    I need to remove 10 Seconds from a Datetime Value.
    Somethin like This:

    This date
    07/24/2003 14:25:02
    I want it like this
    07/24/2003 14:24:52


    Suggestions?
    Diogo Hudson Dias
    DBA - SQL 6.5/7.0/2000
    ASBACE - ATP

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    select DATEADD(ss, -10, date_column) from table
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •