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

go to bug id or search bugs for

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 Developer Edit
 [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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Thu Oct 30 22:00:01 2025 UTC