what about the 'today', 'yesterday', 'tomorrow' literals - are they out too?
-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: Wednesday, 21 August 2002 21:52
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] GetDate function for Firebird


SQL92 has different levels of compliance - entry, intermediate and full
(I believe).

It might be that (without looking) CURRENT_stuff is intermediate level or
something...

The NOW keyword is not standard as far as I know.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> sorry... old habits... but you say SQL92... the now function was around

ages

> ago when IB was always claiming SQL92 compliance. Was NOW never

compliant?

>
>
> NOW is the old way - the new and preferred way
> is to use the SQL92 CURRENT_TIME/DATE/TIMESTAMP
> functions.
>
> Martijn Tonies

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]