daisypolly
Programmer
I am having some problem with this query:
SELECT Jaso.dan_LOBTB028PATENT,
(DAYS(CURRENT_DATE)-DAYS(jason.datecreated))/30
FROM Video
In the line where the days
function starts this whole line is getting the diffrence between todays date
and the date in the column(Datecreated) field. Right now I am getting a
number like 12 or 6. I cannot get decimals so how can I get the decimals to
show also.For example like 12.6 or 6.3.
Thanks a lot,
daisy
SELECT Jaso.dan_LOBTB028PATENT,
(DAYS(CURRENT_DATE)-DAYS(jason.datecreated))/30
FROM Video
In the line where the days
function starts this whole line is getting the diffrence between todays date
and the date in the column(Datecreated) field. Right now I am getting a
number like 12 or 6. I cannot get decimals so how can I get the decimals to
show also.For example like 12.6 or 6.3.
Thanks a lot,
daisy