From: | "ben sewell" <mosherben(at)gmail(dot)com> |
---|---|
To: | "roy simkes" <roysimkes(at)hotmail(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: pgsql Date accept hours minutes and seconds |
Date: | 2006-08-16 10:21:40 |
Message-ID: | bf6c74d80608160321o1722a128y36571fe600fc3249@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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>
>
From | Date | Subject | |
---|---|---|---|
Next Message | roy simkes | 2006-08-16 10:41:46 | Re: pgsql Date accept hours minutes and seconds |
Previous Message | roy simkes | 2006-08-16 10:04:50 | pgsql Date accept hours minutes and seconds |