YEAR() and MONTH() not working...?

[Ruslan Zasukhin]

on 2/21/03 7:06 PM, Michael Geary at listmail at gearyweb.com wrote:

> In ViSQL with my DB I enter:
> 
> "select
> Documents.DocDate
> from
> Documents
> "
> and I get 322 rows.
> 
> But when I enter:
> 
> "select
> YEAR(Documents.DocDate)
> from
> Documents
> "
> 
> I get 0 rows.

Michael, current version do not support function directly in SQL.

You need use BaseObject methods for this.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------