I would take the number of seconds, divide it out;


There are 31536000 Seconds in a year so store that value in a variable as 1 or 2, ect depending upon how many years you have.

Subtract 31536000 * (the value stored from above) from your starting value to get the remaining time. Then do the same for days, then minutes, then seconds.

Do not do this for months as each month has varying number of days....

Not sure exactly what you are asking. If you want to see the value of a field called 'Category' for every record in the table you would do this:


SELECT Category
FROM YourTableNameHe re

If you only want to see the unique Category values (Lets say there are three records in your table and for the Category field each have the same value of 'Customer' then my quesry above would list Customer three times,...