Search Result

i have a date in student.DOB

and i want to get out the student's age. year-months-days old

i basically want to do

current date - student.DOB

please show me how to do this, and what formate my student.DOB date should be in, it currently is in

6/06/1985


MSSQL 2005

Hi,

I have a table called Bookings which has two important columns;
Booking_Start_T ime and Booking_End_Tim e. These columns are both of type
DATETIME. Given any day how can I calculate how many hours are available
between the hours of 09.00 and 17.30 so a user can see at a glance how many
hours they have unbooked on a particular day (i.e. 8.5 hours less the time
of any bookings on that day), can this be done...