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 Add Comment Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
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-2024 The PHP Group
All rights reserved. 		Last updated: Thu Apr 25 04:01:38 2024 UTC