--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> Lee,
>
> At 08:25 PM 24/05/2004 +0000, you wrote:
> >I searched this site for UNIX_TIMESTAMP and other places in order to
> >know how to deal with this in FB15. I'm converting a MySQL system and
> >this is in a query that is blowing up on me. Here's the query and if
> >anyone has any ideas on how do deal with this, I would love to hear
> >your comments.
> >
> >$Query = "SELECT ID, Headline, Summary, Body, Location, " .
> >"UNIX_TIMESTAMP(Expires) AS Expires, DisplayPrecedence " .
> >"FROM news " .
> >"WHERE expires > 'NOW()' ";
>
> Firebird uses standard SQL and doesn't support platform-specific
> formats. Find out what the UNIX_TIMESTAMP format represents and use

CAST

> if necessary. The date literal 'NOW' is supported, but deprecated, and
> needs to be cast to a TIMESTAMP type in Firebird for comparisons. You
> would do better to replace it with the standard SQL context variable
> CURRENT_TIMESTAMP.
>
> If your EXPIRES column is already a TIMESTAMP type, simply remove

the MySQL

> function call. If it is a DATE type, then use
> WHERE CAST(Expires as TIMESTAMP) > CURRENT_TIMESTAMP. The CAST will
> convert the DATE to a TIMESTAMP with a time part of '00:00:00.0000'.

If

> you are only wanting to compare a DATE with a DATE, then replace the

WHERE

> clause with
> WHERE Expires > CURRENT_DATE.
>

CURRENT_TIMESTAMP worked great, THANKS! LEE