hi all
Here is my problem
I have taken date as timestamp without time zone in my postgresql database table
That de SQL script of my Database
CREATE DATABASE datacenter
WITH OWNER = postgres
ENCODING = 'LATIN1'
TABLESPACE = pg_default;
ALTER DATABASE datacenter SET DateStyle=sql, dmy;
See: DateStyle=sql, dmy;
See that now I can imput date in South American Date style 30-04-2007. DD/MM/YYYY without any messages of error
After Built in the php page it doesnt show anything in the column
I think it doesnt show anything because there are some type of control on the datestyle
In the Visual Editor tab, I have selected List page, double click on the field, selected Custom
In the three items, short date, long date, datetime, After Built, it doesnt show anything in the column
Could you advise me how is the code that I have to use like this?? $date = gmdate("l F d Y h:i", ($row['date'] + 5.5*3600)); I found out this code in the forum
on the "View as" settings dialog and add my code:
In the Visual Editor tab, I have selected List page, double click on the field, selected empty item.
After Built in the php page show 10/08/2006 23:02:43.796 in the column
To be Brief:
I would like that the date should be shown as 30-04-2007 23:02pm instead of 30/04/2007 23:02:43.796 (2007-04-30 23:02:43.796 - which is stored in database).
Waiting for your soon reply...
Best regards
Hugo