Wow, I couldn't have asked fopr more.

Thanks, Neville

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <IB-Conversions@yahoogroups.com>; <IB-Conversions@yahoogroups.com>
Sent: Sunday, November 16, 2003 9:25 PM
Subject: Re: [IB-Conversions] sysdate


> At 06:40 PM 16/11/2003 +0000, nevillerichards wrote:
> >Working with Oracle (sorry!), I have found the function SYSDATE useful.
> >
> >Does Firebird have an equivalent?
>
> Several:
> CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, 'Now', 'Today', 'Tomorrow'
> and 'Yesterday'. The first three are SQL standard.
>
> select current_timestamp as time_stamp from rdb$database
> is equivalent to
> select sysdate as time_stamp from dual
>
> Helen
>
>
>
>
> To unsubscribe from this group, send an email to:
> IB-Conversions-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>