Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Date format problem

0 views
Skip to first unread message

Simon Moses

unread,
Sep 16, 2004, 3:52:03 AM9/16/04
to
dear sir,
i am getting date in 'yyyy-mm-dd' format when i use
rs.getDate() method. i want it to be in 'dd/mm/yyyy'
format.
'select current_timestamp' is giving 'dd/mm/yyyy' in
psql.
how to change to 'dd/mm/yyyy' format in java
programme? thanks in advance.
-Simon Moses.
Bangalore
India.

=====
**************************
Visit My Home Page
http://www.geocities.com/ks_moses
updated: 22 February 2004.
Simon Moses
**************************



__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Kris Jurka

unread,
Sep 16, 2004, 4:40:31 AM9/16/04
to

On Thu, 16 Sep 2004, Simon Moses wrote:

> dear sir,
> i am getting date in 'yyyy-mm-dd' format when i use
> rs.getDate() method. i want it to be in 'dd/mm/yyyy'
> format.

This is the format that the Date class' toString() method uses, so this is
an application thing, not a driver property. See
java.text.SimpleDateFormat.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

0 new messages