php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #75324 No provision for milliseconds in timestamps
Submitted: 2017-10-06 01:39 UTC Modified: 2021-03-31 11:39 UTC
From: dmiller at amfes dot com Assigned:
Status: Suspended Package: InterBase related
PHP Version: 7.0.24 OS: any
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: dmiller at amfes dot com
New email:
PHP Version: OS:

 

 [2017-10-06 01:39 UTC] dmiller at amfes dot com 
Description:
------------
If a timestamp field is filled with the value of current_timestamp from a stored procedure or trigger, then the timestamp field will include millisecond information. "Pure" Firebird queries, such as from Flamerobin, will show the milliseconds. However, queries using the ibase_ functions return using the ibase.timestampformat per the documentation, which uses the strftime function - which has no provision for milliseconds.

A workaround for the strftime limitation was given in http://php.net/manual/en/function.strftime.php#114532

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2018-03-03 00:32 UTC] keymaker dot 7 at gmail dot com 
Tambien se puede cambiar a varchar para obtener la fecha completa:
LEFT(CAST(SERVERTIME AS VARCHAR(24)),23)
 [2021-03-31 11:39 UTC] cmb@php.net
-Status: Open +Status: Suspended
 [2021-03-31 11:39 UTC] cmb@php.net 
The interbase extension is moved to PECL[1] as of PHP 7.4.0, and
is looking for a new maintainer.  Until a new maintainer is found,
I suspend this ticket.

Consider to use the bundled PDO_Firebird extension, or the
php-firebird package[2] instead.

[1] <https://pecl.php.net/package/interbase>
[2] <https://github.com/FirebirdSQL/php-firebird>
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Fri Dec 27 19:01:28 2024 UTC