Hi Ronaldo,

Try

SELECT EXTRACT( MONTH FROM CURRENT_DATE) FROM RDB$DATABASE
SELECT EXTRACT( DAY FROM CURRENT_DATE) FROM RDB$DATABASE
SELECT EXTRACT( YEAR FROM CURRENT_DATE) FROM RDB$DATABASE


[]'s

> ----- Mensagem original -----
> De: ronaldorezende [SMTP:ronaldinho79@...]
> Enviada em: quarta-feira, 19 de março de 2003 16:03
> Para: ib-support@yahoogroups.com
> Assunto: [ib-support] Re: date of server
>
> 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
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>