Date & time query question (sql-server 2008)
- by Gold
hi
i have table that contain date and time field.
id|date|time
=========
1|01/01/2001|10:45
2|01/02/2002|11:45
3|01/03/2003|12:45
4|01/04/2004|12:55
i need to know the difference between the MAX(date) and the MIN(date)
and the MAX(time) and the MIN(time)
something like.... MAX(date)-MIN(date) ???.....
thank's in advance