"pali" <pa**********@gmail.comwrote in message
news:11*********************@e34g2000pro.googlegro ups.com...
>
I have a char column that contains date/time information
(YYYYMMDDTTTTTT) in the following format: 20071002160603
What is the most efficient way to show this information in a query
result as "10/02/2007 16:06:03"?
Thanks in advance.
SUBSTR(COL1, 5,2)||'/'||SUBSTR(COL1, 7,2)||'/'||SUBSTR(COL1, 1,4)||'
'||SUBSTR(COL1, 9,2)||:||.....
I will let you finish the rest of it.