Home » RDBMS Server » Server Administration » Re: Data formats
Re: Data formats [message #373321] |
Wed, 11 April 2001 10:24 |
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 character type. 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
|
|
|
|
|
Goto Forum:
Current Time: Mon Jan 13 15:10:30 CST 2025
|