Can anyone help me with the query to convert a decimal eg (19890523) to date format (1989-05-23)....
Asuming your decimal column has alwys dates in the format yyyymmdd
the following should work
select cast(19890523 as decimal(15,0)) as dt_in,
cast((dt_in - 19000000) as date);
I don't think this is a complete information you have provided for any of the volunteers. No sample data, no version info.
It is always easy to put your Teradata version info along with some input data & your required output in a clear manner. Otherwise it is impossinble for us to predict whatever you are looking for.
You can use CAST function to do that. Now, if you provide the sample input then we may look into the actual case.