File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Struts and the fly likes how to retreive date Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "how to retreive date " Watch "how to retreive date " New topic

how to retreive date

smitha mano
Ranch Hand

Joined: Sep 26, 2005
Posts: 70
i am using postesql 8.1.

in my table test have one field insertdate its data type is "date".

manually i entered a date, 29-11-2005 , i got error

AN error has occured.
ERROR: date/time field value out of range:"29-11-2005"
HINT: perhaps you need a different "datestyle"setting.

when i entered this way date 2005-11-29 its stored in the table.

but actually i needed, in sql query, 29-11-2005 format. how i can retrive date format 2005-11-29 to 29-11-2005?

please help me
Don't get me started about those stupid light bulbs.
subject: how to retreive date
It's not a secret anymore!