wood burning stoves 2.0*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "how to retreive date " Watch "how to retreive date " New topic
Author

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
 
wood burning stoves
 
subject: how to retreive date
 
Similar Threads
How to change date format yyyy/mm/dd to dd/mm/yyyy
Convert a String with a date valus for Oracle
Date comparison...Help please!
How to retrieve a date value
problem with sql query to_date