I want to convert source Date format "CCYYMMD" to "CCYY-MM-DD23.59.59.999999" in to the target for example source date is 19980224it should be in target 1998-02-24.23.59.59.999999

  • Interview Candidate
  • 1
  • 3200

Showing Answers 1 - 1 of 1 Answers

praveen

  • Jul 3rd, 2006
 

Hi all,

let first conver it into to_date and thenm to_char and then concate with .23.59.59.999999

this way to_char(to_date('column name','ccyymmd') ,'ccyy-mm-dd')||.28.59.59.9999999

try for this

regards

praveen

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions