php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #23009 pg_select with timestamp
Submitted: 2003-04-01 15:41 UTC Modified: 2003-04-02 10:28 UTC
From: leoguti at iband dot net Assigned: helly (profile)
Status: Closed Package: PostgreSQL related
PHP Version: 4.3.1 OS: ANY
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: leoguti at iband dot net
New email:
PHP Version: OS:

 

 [2003-04-01 15:41 UTC] leoguti at iband dot net
I can't do that the function work with timestamp with time zone data type.

I have the table 
create table proob(
 field_proob timestamp with time zone
);

an I tried to do 
<?
$a=array("field_proob"=>"2003-03-30 22:47:52.657715-05");
echo pg_insert($conexion,"proob",$a);
?>

With other data types this function work but with this don't.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-04-01 16:18 UTC] helly@php.net
Read the manual on PostgreSQL:

uni=# create table t ( t timestamp with time zone);
CREATE
uni=# insert into t values ('2003-04-01 22:00:00.0000 GMT');
INSERT 167462 1
 [2003-04-01 16:49 UTC] helly@php.net
Ah sorry, now i know what you meant.
 [2003-04-01 17:29 UTC] jay@php.net
This should be fixed in CVS now. 
 
J 
 [2003-04-02 10:28 UTC] leoguti at iband dot net
Sorry, my summary must be pg_insert with timestamp 
problem, nor pg_select
 
PHP Copyright © 2001-2019 The PHP Group
All rights reserved.
Last updated: Sat Oct 19 02:01:27 2019 UTC