and 'YEAR', 'MONTH', 'DAY', 'NOW' ?
How can I use all of this in select ?

--- In ib-support@yahoogroups.com, Berenger Enselme <BEnselme@N...>
wrote:

>
>
> > -----Original Message-----
> > From: ronaldorezende [mailto:ronaldinho79@b...]
> > Sent: Wednesday, March 19, 2003 1:47 PM
> > To: ib-support@yahoogroups.com
> > Subject: [ib-support] date of server
> >
> >
> > How can I obtein the date of ther server in a select ?
>
> SELECT CURRENT_DATE FROM RDB$DATABASE
>
> if you just want the date and nothing else... RDB$DATABASE is a

system table

> used here because it is guaranteed to contain 1 and only 1 record...
>
> You can of course use CURRENT_DATE in other SELECT expressions...
>
> Berenger Enselme