Hi Guys,

My database has a date time stamp, heres an example.

1/5/2001 9:46:23 AM
D/M/YYYY H:MM:SS ??

I need to know the number of days/hours/mins since this date using sql. Is this possible? I can do it with Now() to find the days, but I could really do with it being a little more detailed.

Anyhelp much appreciated as always,

Paul.