Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to retreive date

 
smitha mano
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic