SQL Server Performance

times

Discussion in 'Getting Started' started by menssanvi, May 25, 2010.

  1. menssanvi New Member

    SQL server how can I combine times such 6.30 - 7.00 and 7.00-7.30 to become 1hr gap instead of 1/2hr as it is now?
  2. Luis Martin Moderator

    Welcome to the forum!!
    Could you explain a little more your question, please.
  3. atulmar New Member

    Its not 1/2 hour, is it?
  4. menssanvi New Member

    Right now when I run my select query, it is returning the datatime as set in the db for every 1/2hr. What I am trying to do is run a query that will automaticaly add up the 1/2hr to 1hr. Example below:
    login name login time money_spent
    mimi 6:00-6:30 2.50
    mimi 6.30-7:00 5.70

Share This Page