Re: Calculating with dates

[Sölving Björn <bjorn.solving@TEAM.ICL.SE>]

Hello Jack

When using SqlBase I simply let the database engine do the calculation
in an SQL fashion. Something like this in the select part
sysdate-thisdate &days_old
or
sysdate-#this_date &days_old

Bjorn Solving, ICL Sweden (running SQR 2.28!)
--------------------------------
Gemba Service:
>Hello everybody,
>
>I'm trying to do some calculations with a date range. My input contains two
>strings $startdate, $enddate. From these two dates I want to calculate number
of
>days. Determine the month we are in, for graphs by month. Determine the
>weeknumber.
>I need this for Oracle and SQLbase, is there anayone who can help me on this,
>the reference book doesn't quite give me the clue.
>
>
>Jack Lok
>Gemba Service
>