IssacJones
asked on
SQL year and month e.g. 8:4
Hi
I have a table that stores a year and month age e.g. 8:4 (8 years and 4 months old) in two columns e.g.
8:4 9:11
I would like to be able to select on this table so I can select rows that fall into a range which I supply e.g. find rows in the table where the two columns have values that fall into
8:7 9:02
That is, the row I gave first would contain this range I've supplied.
Can anybody help?
John
I have a table that stores a year and month age e.g. 8:4 (8 years and 4 months old) in two columns e.g.
8:4 9:11
I would like to be able to select on this table so I can select rows that fall into a range which I supply e.g. find rows in the table where the two columns have values that fall into
8:7 9:02
That is, the row I gave first would contain this range I've supplied.
Can anybody help?
John
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
e.g., Try: SELECT CAST('24:1' AS DATETIME);
Nice suggestion, though, @deighton!