| Re: Data formats [message #373320] |
Wed, 11 April 2001 10:23 |
Neal Hawman
Messages: 14
Registered: April 2001
|
Junior Member |
|
|
You're using to_date, so Oracle will convert it into a proper date format. It will then be displayed in a utility such as SQLPLUS in whatever the default format for displaying dates is. This is defined by the parameter NLS_DATE_FORMAT and is usually 'DD-MON-YY'.
I presume that wwv_thingattributes.value is of type CHAR. If you want to display it in the same format as it was in the original table, then you don't need TO_DATE in the select clause (although you will need it in the order by clause so that the sorting is correct).
Neal
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
