How to retrieve a date value
smitha mano
Ranch Hand
Posts: 70
posted 11 years ago
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
[ November 29, 2005: Message edited by: Bear Bibeault ]
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
[ November 29, 2005: Message edited by: Bear Bibeault ]
| Don't get me started about those stupid light bulbs. |