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 Novice > date formatting...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 3158 of 3215
Post > Topic >>

date formatting question

by rterry@[EMAIL PROTECTED] (richard terry) Jul 3, 2008 at 03:09 PM

Hi,

I'm using gambas to save some data to the database, and use the date from
a 
textbox to write to the database in format 'dd/mm/yyyy', however when I
look 
at the database using pgadmin3 , the date is stored as eg 2008/10/02 
yyyy/dd/mm.

If I re-display it with  a formatting option like:  
Format(referral.date, "dd/mm/yyyy")    then it looks ok in my program

does it matter that is 'round the wrong way' in the database, or is there
some 
way to tell the database to do it the other way around.

Thanks in anticipation.

richard



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




 2 Posts in Topic:
date formatting question
rterry@[EMAIL PROTECTED]   2008-07-03 15:09:10 
Re: date formatting question
fbax@[EMAIL PROTECTED] (  2008-07-03 06:27:52 

Post A Reply:
  Go here to Signup

AddThis Feed Button


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

Contact
tan12V112 Sun Sep 7 7:24:33 CDT 2008.