HI bill
Try to cast the field to the datetime type
'ur_string_goes_here'::datetime
Hope this will help
Anand Raman
- Original Message -
From: Bill Barnes <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 28, 2000 6:09 PM
Subject: [GENERAL] date format problem
> Hello Li
--- "Robert B. Easter" <[EMAIL PROTECTED]> wrote:
>
>Try recompiling php 4.0RC1 or whatever is current with the latest Apache
>source (1.3.12). I'm thinking maybe you are not running php as compiled into
>the server.
Thanks - I had PHP compiled into the server - though I may try the recompile a
HI guys
Thanx for the quick reply..
When i tried compiling jdbc for postgresql700 I encounter the following error
postgres@localhost > make jdbc1
(echo "package postgresql;" ;\
echo "public class DriverClass {" ;\
echo "public static String connectClass=\"postgresql.jdbc1.Connection\";" ;\
e
On Tue, 02 May 2000, surfer girl wrote:
> Hi Robert,
>
> Thanks for the code. I tried the code, and it works fine (no errors) except instead
>of getting an image output, it outputs "/tmp/php08543baa" to the browser or something
>similar (just like my code). Am I missing something where I shoul
Hi Robert,
Thanks for the code. I tried the code, and it works fine (no errors) except instead of
getting an image output, it outputs "/tmp/php08543baa" to the browser or something
similar (just like my code). Am I missing something where I should be transferring a
temp file to something web-
On Tue, 02 May 2000, Tom Cook wrote:
> On Tue, 2 May 2000, Peter Eisentraut wrote:
>
> > Anand Raman writes:
> >
> > > Is there anything equivalent to the enumerated data types in
> > > postgresql..
> >
> > You might find that strings with check constraints will do the job, e.g.
> >
> > create
I was thinking of trying something like the following to automatically delete
rows from tables that reference large objects when the large object is
unlinked. It would depend on pg_class having a PRIMARY key (on the hidden
'oid' column in this possible example):
-- this is a generic table to ju
On Tue, 02 May 2000, surfer girl wrote:
> Hello,
>
> I am trying to write a program that will input and output images from a Postgres
>database using PHP.
I made a very simple display image routine as follows:
---
--
On Tue, 2 May 2000, Peter Eisentraut wrote:
> Anand Raman writes:
>
> > Is there anything equivalent to the enumerated data types in
> > postgresql..
>
> You might find that strings with check constraints will do the job, e.g.
>
> create table my_tbl (
> ...
> color text check color in ('blu
On Tue, 2 May 2000, Anand Raman wrote:
> Hi guys
> I tried compliling JDBC 1.2 driver for postgresql7.0 .. However things didnt work
>out as expected..
Hmmm, a descriptive type. _What_ went wrong?
> Can anybody please send it to me thru a personal email.. The site has a version of
>postgresql
I don't really follow how configure works (yet), however, I think this may be an
"OR" rather than an "AND". I believe (!) that different version of readline did
this differently and that is what is being checked for.
Mark
"Michael S. Kelly" wrote:
> I've got the same problem with readline and p
* Jack Zhu <[EMAIL PROTECTED]> [000502 15:52] wrote:
> Hi, all:
>
> PostgreSQL 7 Beta 5 on Red hat Linux 6.0
>
> We have a a table which has a column col_a with 'timestamp' data type. When
> insert time value to this column, we use format which is 'MM/DD/
> HH24:MI:SS' (such as '05/01/2000 1
Hi, all:
PostgreSQL 7 Beta 5 on Red hat Linux 6.0
We have a a table which has a column col_a with 'timestamp' data type. When
insert time value to this column, we use format which is 'MM/DD/
HH24:MI:SS' (such as '05/01/2000 13:20:02'). Insertion is OK.
But when we try to read this column, t
The following may help, substitiuting "tablename";
select a.attname
from pg_index i, pg_attribute a
where i.indrelid =
(select oid as class_oid from pg_class where relname = 'tablename')
and i.indkey[0] = a.attnum
and a.attrelid = i.indrelid
Hi,
PostgreSQL 7 Beta 5 on Red hat Linux 6.0
JDBC 6.5-1.1 driver, Java 1.1.7B, download JDBC driver from
http://www.retep.org.uk/postgres/
We have a a table which has a column col_a with 'timestamp' data type. When
insert time value to this column, we use format which is 'MM/DD/
HH24:MI:SS'
You cannot use a "name" in a WHERE clause and aliases are specifically for
aliasing table names only. (An alias reference would look like "WHERE
alias.column_name > 10".) The documentation for "AS name" usage specifically
says a "name" cannot be used in a WHERE clause. I believe you will have to
On Tue, 2 May 2000, surfer girl wrote:
> Hello,
>
> I am trying to write a program that will input and output images from a Postgres
>database using PHP.
>
> The inputting seems to be going fine - well, it seems to be fine, since I can't
>test it because it's the output I'm stuck on.
>
>
Anand Raman writes:
> Is there anything equivalent to the enumerated data types in
> postgresql..
You might find that strings with check constraints will do the job, e.g.
create table my_tbl (
...
color text check color in ('blue', 'green', 'white'),
...
);
--
Peter Eisentraut
> I've got the same problem with readline and psql using 7.0 RC1.
>
> I found that there was something odd when ran configure. Here's the
> readline stuff I grepped out of config.cache:
>
> ac_cv_header_readline_h=${ac_cv_header_readline_h='no'}
>
ac_cv_header_readline_history_h=${ac_cv_header_
1. Don't Gamble when tired.
2. Don't Gamble when hungry.
3. Don't Gamble when distracted.
4. Don't Gamble with Money you need.
5. Once won, the money is yours. You are not playing on free money.
6. Check out this site!
http://www.go2jackpots.com/3355
20 matches
Mail list logo
