locked
Increment hour by 1 RRS feed

  • Question

  • Hey guys,

    I am doing a project that has start time and end time.  i was given only the start time of cases, but not the end time. 

    for example:

     

    start time

    01:30:00

    10:00:00

    09:24:00

    11:25:00

    .

    .

    .

    .

    It was like, thousands of start time.  I need to create an end time (smalldatetime) which is one hour passed the start time.  can anyone tell me how to do it in sql query?  thanks.

     

    Jul

    Friday, April 27, 2007 11:16 PM

Answers