Hi,
I'm trying to convert the long datatype to timestamp/varchar2. I'm failing in conversion to use to_char/cast/to_timestamp functions. Basically, I'm trying to convert the high_value column in the user_tab_partitions where in which high_value is a long datatype.
select * from user_tab_partitions;
| X_Partition | NO | RS_OLD_RANGE | 0 | TIMESTAMP' 2014-01-01 00:00:00' | 31 | 1 | DATA1 | 10 | |
| X_Partition | NO | SYS_P172 | 0 | TIMESTAMP' 2014-02-01 00:00:00' | 31 | 2 | DATA1 | 10 | |
| X_Partition | NO | SYS_P173 | 0 | TIMESTAMP' 2014-03-01 00:00:00' | 31 | 3 | DATA1 | 10 | |
| X_Partition | NO | SYS_P174 | 0 | TIMESTAMP' 2014-04-01 00:00:00' | 31 | 4 | DATA1 | 10 | |
| X_Partition | NO | SYS_P175 | 0 | TIMESTAMP' 2014-05-01 00:00:00' | 31 | 5 | DATA1 | 10 | |
| X_Partition | NO | SYS_P176 | 0 | TIMESTAMP' 2014-06-01 00:00:00' | 31 | 6 | DATA1 | 10 | |
| X_Partition | NO | SYS_P177 | 0 | TIMESTAMP' 2014-07-01 00:00:00' | 31 | 7 | DATA1 | 10 | |
| X_Partition | NO | SYS_P178 | 0 | TIMESTAMP' 2014-08-01 00:00:00' | 31 | 8 | DATA1 | 10 | |
| X_Partition | NO | SYS_P179 | 0 | TIMESTAMP' 2014-09-01 00:00:00' | 31 | 9 | DATA1 | 10 | |
| X_Partition | NO | SYS_P180 | 0 | TIMESTAMP' 2014-10-01 00:00:00' | 31 | 10 | DATA1 | 10 | |
| X_Partition | NO | SYS_P181 | 0 | TIMESTAMP' 2014-11-01 00:00:00' | 31 | 11 | DATA1 | 10 | |
| X_Partition | NO | SYS_P182 | 0 | TIMESTAMP' 2014-12-01 00:00:00' | 31 | 12 | DATA1 | 10 | |
| X_Partition | NO | SYS_P166 | 0 | TIMESTAMP' 2015-01-01 00:00:00' | 31 | 13 | DATA1 | 10 | |
| X_Partition | NO | SYS_P170 | 0 | TIMESTAMP' 2015-02-01 00:00:00' | 31 | 14 | DATA1 | 10 | |
| X_Partition | NO | SYS_P167 | 0 | TIMESTAMP' 2015-03-01 00:00:00' | 31 | 15 | DATA1 | 10 | |
| X_Partition | NO | SYS_P171 | 0 | TIMESTAMP' 2015-04-01 00:00:00' | 31 | 16 | DATA1 | 10 | |
| X_Partition | NO | SYS_P168 | 0 | TIMESTAMP' 2015-05-01 00:00:00' | 31 | 17 | DATA1 | 10 | |
| X_Partition | NO | SYS_P169 | 0 | TIMESTAMP' 2015-06-01 00:00:00' | 31 | 18 | DATA1 | 10 | |