| Subject | RE: [ib-support] date of server |
|---|---|
| Author | Berenger Enselme |
| Post date | 2003-03-19T18:52:32Z |
> -----Original Message-----SELECT CURRENT_DATE FROM RDB$DATABASE
> From: ronaldorezende [mailto:ronaldinho79@...]
> 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 ?
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