Home » RDBMS Server » Server Administration » Re: Data formats
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
Previous Topic: Performance
Next Topic: Re: Data formats
Goto Forum:
  


Current Time: Mon Dec 23 09:37:15 CST 2024