Hi,
Is there any way to find system date using SQL Query in Baan?
(like sysdate in Oracle)
Regards,
Sat..

The Baan Tools function DATE.NUM() returns the current system date in a format that can be used by Baan SQL.

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.

Actually I want something like this,

Select systemdate from table;

Is there any system table in Baan which gives the systemdate??

Thanks,

:rolleyes: :rolleyes: :rolleyes:

As gguymer said, the systemdate in BaaN is date.num()

you can fill a variable "today" = date.num()

that's all.

I think you mean "Easy SQL" ????

regards bdittmar