Re: pgsql Date accept hours minutes and seconds

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/static/datatype-datetime.html#DATATYPE-DATETIME-INPUT
for
more information.

Regards,
Ben

On 8/16/06, roy simkes <roysimkes(at)hotmail(dot)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>
>