formating date

Shell Programming and Scripting
1

Guys

I have a date value like this in a table -> 2006-12-29 12:57:08(data type varchar2(25))

I am trying to subtract this column from sysdate.

I am unable to do that. can u guys suggest me a way to do this..

2 
sql > SELECT                                                                  
   SYSDATE - TO_DATE('2006-12-29 12:57:08','YYYY-MM-DD HH:MI:SS')       
FROM DUAL;                                                              

SYSDATE-TO_DATE('2006-12-2912:57:08','YYYY-MM-DDHH:MI:SS')
----------------------------------------------------------
                                                5.06428241
1 Like
3

thank you.. it worked fine,