Hi

new to elevateDB from DBISAM

this does not work in EDB

Select * from Planner where  CAST(StartTime as Date)='2010-12-31'

but this does

Select * from Planner where  CAST(StartTime as Date)=cAST('2010-12-31' AS DATE)

Is this right?

Is 'yyyy-mm-dd' right?

Thanks in advance

Peter

Peter

> Select * from Planner where  CAST(StartTime as Date)=cAST('2010-12-31' AS DATE)
>

Alternatively

Select * from Planner where  CAST(StartTime as Date)= Date '2010-12-31'

John

Peter


As John says - you may also find it useful to read up on INTERVALs if you do any date arithmetic. You can no longer do things like (date1 -  date2) > 90 in SQL

Roy Lambert [Team Elevate]

Peter

CAST('2010-12-31' AS DATE)

Still works. You would use it:

WHERE StartDate > CAST('2012-12-31' as DATE)

You can also use:

DATE '2012-12-31'

as another poster mentions.


WHERE StartDate > DATE '2012-12-31'

--

As Roy mentions where you would have written


WHERE StartDate > Current_Date - 90

You now have to write:

WHERE StartDate > Current_Date - INTERVAL '90' DAY

Or you might want to get more or less the same result with:

WHERE StartDate > Current_Date - INTERVAL '3' MONTH

--

I found INTERVALs a pain when starting EDB, and the date handling makes SQL more verbose than with DBISAM. However they do have benefits ... as you can now specify intervals such as working weeks, and whole months much more accurately.

With my SQL Scripts from DBISAM I did a lot of Find and Replace to cope with the changes of querying dates ... and that worked pretty well.

Thanks Guys

I'm on a steep learning curve with this!!!!!

Peter