Search Postgresql Archives
date format
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: "pg >> Postgres General" <pgsql-general@xxxxxxxxxxxxxx>
- Subject: date format
- From: David Rysdam <drysdam@xxxxxxxxxx>
- Date: Thu, 08 Dec 2005 12:44:31 -0500
- User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.11) Gecko/20050729
I could swear (but I don't think I can prove at this point) that 8.0
beta3 returned timestamps with milliseconds, like this:
YYYY-MM-DD HH24:MI:SS.MS
But 8.1 isn't doing that. I see functions to format the date, but that
would require me to change all my existing SQL to specifically ask for
the milliseconds. There's also the "set datestyle" thing, but the
granularity doesn't exist to specify an exact format such as the above.
Is there a way to tell postgres *exactly* what I want the *default* date
output format to be?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]