extract date postgres

[Anon]

Hi everybody!!

I want to extract a date stored in a postgres
database .
when I use date("Y-m-d") it returns the local date. when I use date("Y-m-d", pg_result($con,0,'date_var')) it returns a date that is different the one I stored.

How can I told the date function that I want to format the date stored in tha database not the local date ?

Thanks,

.alvaro.

[toma42]

Use this:

CREATE FUNCTION unix_timestamp (timestamp) RETURNS float8 AS 'SELECT date_part(\'epoch\', $1) AS RESULT;' LANGUAGE 'sql';

then select the datetime using unix_timestamp(datetime)

This is a port of the unix_timestamp from mysql and works fine.

[Anon]

We use to_char(datefield,'dd Mon yyyy hh24:mm') which is a postgres function that formats the date function ie select to_char(datestarted,'dd Mon yyyy hh24:mm') as datestarted from testtable but also have the same problems...

Alvaro wrote:

Hi everybody!!

I want to extract a date stored in a postgres
database .
when I use date("Y-m-d") it returns the local date. when I use date("Y-m-d", pg_result($con,0,'date_var')) it returns a date that is different the one I stored.

How can I told the date function that I want to format the date stored in tha database not the local date ?

Thanks,

.alvaro.

[toma42]

Justin, using the solution I posted above, you can get unix timestamps from postgresql easily and easily manipulate them in php. Research it...I'm sure you'll find my way the right way (and it's portable between databases).

Tom

[Anon]

Hey Tom!!!!

Just want to say a big thank you (THANK YOU) for that solution. It is far more elegant than mine, we will adopt it from now on.

regards
Justin

http://www.thewallpaperking.com