Subject Re[2]: [firebird-php] timestamp milliseconds
Author Daniel Miller
well...something like:

using arcane incantations of ibase_query...perform something similar to
"select SOMETIME from SOMETABLE rows 1;" and store in $phpvar.

So $phpvar now has a timestamp - but lacking the milliseconds.

Now, go looking for that:
"select VALUE, ABLE, INFO from SOMEOTHERTABLE where SOMETIME = $phpvar"

This will return a null set. So my functional but highly offensive
workaround is:
(SOMETIME - cast($phpvar as timestamp)) > 0
and (SOMETIME - cast($phpvar as timestamp)) < .001
and datediff(second from (SOMETIME - cast($phpvar as timestamp)) = 0"

There has got to be a better way to do this.

On 10/5/2017 1:58:20 AM, "Lester Caine lester@...
[firebird-php]" <> wrote:

>On 05/10/17 09:36, 'Daniel Miller' dmiller@... [firebird-php]
>>It seems when querying a table with a timestamp column, the retrieved
>>value does not contain the milliseconds - even though they are stored
>>and visible in Flamerobin. How can I include the subseconds in the
>I think we need a bit more data on what you are actually using in php
>work out just where the problem is. I have to trim the microseconds
>displaying my timestamps ...
>Lester Caine - G8HFL
>Contact -
>L.S.Caine Electronic Services -
>EnquirySolve -
>Model Engineers Digital Workshop -
>Rainbow Digital Media -
>Posted by: Lester Caine <lester@...>
>Yahoo Groups Links