pgsql Date accept hours minutes and seconds - Mailing list pgsql-novice

From roy simkes
Subject pgsql Date accept hours minutes and seconds
Date
Msg-id BAY108-W3B09C3D7F1294A5F016F7A14C0@phx.gbl
Whole thread Raw
Responses Re: pgsql Date accept hours minutes and seconds  ("ben sewell" <mosherben@gmail.com>)
List pgsql-novice
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 file 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!

pgsql-novice by date:

Previous
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: Optimal Postgres Development Process, Software
Next
From: "ben sewell"
Date:
Subject: Re: pgsql Date accept hours minutes and seconds