Skip site navigation (1) Skip section navigation (2)

Re: pgsql Date accept hours minutes and seconds

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 (view raw or flat)
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>
>

In response to

pgsql-novice by date

Next:From: roy simkesDate: 2006-08-16 10:41:46
Subject: Re: pgsql Date accept hours minutes and seconds
Previous:From: roy simkesDate: 2006-08-16 10:04:50
Subject: pgsql Date accept hours minutes and seconds

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group