sql server2000
-
hi How to get difference between time i.e column1 have some start time and column2 have some finish time difference between column1 and column2?
-
hi How to get difference between time i.e column1 have some start time and column2 have some finish time difference between column1 and column2?
Look in the online-help for the
datedifffunction. -
hi How to get difference between time i.e column1 have some start time and column2 have some finish time difference between column1 and column2?
Are you looking for this[^] ? Happy Programming
Navaneeth My Website
-
hi How to get difference between time i.e column1 have some start time and column2 have some finish time difference between column1 and column2?
DATEDIFF() function accepts two DATETIME values and a date portion (minute, hour, day, month, and so on) as parameters. DATEDIFF() determines the difference between the two date values passed, expressed in the date portion specified
Regards SG (sgg245@yahoo.co.in)
-
DATEDIFF() function accepts two DATETIME values and a date portion (minute, hour, day, month, and so on) as parameters. DATEDIFF() determines the difference between the two date values passed, expressed in the date portion specified
Regards SG (sgg245@yahoo.co.in)
hi then what should be the data type of that column, so that i can save time only. bec in my requirement i have requested any department for a request. so at what time they received my request and what time they have replayed me i.e i want to calculate how much time taken to complete my request thanks alisha
-
hi then what should be the data type of that column, so that i can save time only. bec in my requirement i have requested any department for a request. so at what time they received my request and what time they have replayed me i.e i want to calculate how much time taken to complete my request thanks alisha
The datatype of the column should be DATETIME... Use the following type query:: select convert(varchar(10), c6, 108) from t1 In this query, Column 'c6' is of DATETIME type and this query will give you only time part of the column and over this you can use DATEDIFF() function...
Regards SG (sgg245@yahoo.co.in)