Hi again,

When I use php's date function to insert a date into the pgsql date field only day month and year are entered as data and hours minutes and seconds are ignored. php's date function takes a format of date. I use "m-d-Y H:i:s" where m= month, d=day etc... I think that I'm doing something wrong in the format and because of that pgsql ignores the minutes. If this is true what is the right format? Or it should be because of my postgresql.conf filein which date syle is ISO, MDY. Maybe I should change this to something else, but what?

Thanks
__________________________________________________ _______________
Try Live.com: where your online world comes together - with news, sports, weather, and much more.
http://www.live.com/getstarted

Hi Roy,
you need to change the type of field where the date and time is stored to a
timestamp.

Have a look at
http://www.postgresql.org/docs/8.1/s...DATETIME-INPUT
for
more information.

Regards,
Ben


On 8/16/06, roy simkes <roysimkes@hotmail.com> wrote:
>
> Hi again,
>
> When I use php's date function to insert a date into the pgsql date field
> only day month and year are entered as data and hours minutes and seconds
> are ignored. php's date function takes a format of date. I use "m-d-Y
> H:i:s" where m= month, d=day etc... I think that I'm doing something wrong
> in the format and because of that pgsql ignores the minutes. If this is true
> what is the right format? Or it should be because of my postgresql.conffile in which date syle is ISO, MDY. Maybe I should change this to something
> else, but what?
>
> Thanks
>
>
> ------------------------------
> With MSN Spaces email straight to your blog. Upload jokes, photos and
> more. It's free! It's free!<http://clk.atdmt.com/MSN/go/msnnksac0030000001msn/direct/01/?href=http://www.imagine-msn.com/spaces>
>