| Subject | Re: [IB-Conversions] sysdate |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-11-16T21:25:29Z |
At 06:40 PM 16/11/2003 +0000, nevillerichards wrote:
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
>Working with Oracle (sorry!), I have found the function SYSDATE useful.Several:
>
>Does Firebird have an equivalent?
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