Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: Date Format...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 3 Topic 15954 of 16941
Post > Topic >>

Re: Date Formatting for dd/mm/yyyy

by artacus@[EMAIL PROTECTED] (Artacus) Jul 3, 2008 at 08:04 AM

J Ottery wrote:
> Hi all.
> I am using Postgres 8.3 with Windows XP Pro.
> System date format is dd/MM/yyyy
> 
> Having problems when I writing records to a database with a single
> 'date' type field.

I may be confused here. You say writing was your problem but it sounds 
like the problem is when you read the records out.

The way dates are displayed is dependent on (and configured in) the 
client not on the server. So if you have a specific format you want your 
  dates displayed then you need to convert them to a string in your query.

Artacus

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 3 Posts in Topic:
Date Formatting for dd/mm/yyyy
J Ottery <jottery@[EMA  2008-07-02 19:43:42 
Re: Date Formatting for dd/mm/yyyy
kgore4@[EMAIL PROTECTED]   2008-07-03 15:42:14 
Re: Date Formatting for dd/mm/yyyy
artacus@[EMAIL PROTECTED]  2008-07-03 08:04:24 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Oct 11 20:24:47 CDT 2008.