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
Status: Closed Package: PostgreSQL related
PHP Version: 4.3.1 OS: ANY
Private report: No CVE-ID:
 [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-2014 The PHP Group
All rights reserved.
Last updated: Thu Apr 17 03:01:55 2014 UTC