Ed Dressel wrote:

>
>
>>If it works for FB but not for IB, then you may have to take a
>>
>>
>different
>
>my mistake. it seems it doesn't work on either--it always returns
>the time fraction. This seems to be different then Helen's
>statements (page 153). The SQL:
>
>select cast (Action_DateTime as date) from ActionLog
>
>should just return the date and not the time.
>
>Could someone confirm that I am doing it right but getting the wrong
>results (which include the time fraction)?
>
>Thanks
>Ed Dressel
>
>

Ed,

If you use Dialect 1 database, then the date data type is both date +
time, i.e. a timestamp.

On Dialect 3 you have 3 diferent datatypes:
1.) Date - just date
2.) Time - just time
3.) Timestamp - Date + Time (the same as date on Dialect 1)

see you !


--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br