var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: converting varchar to date
I have a column which has varchar format but the content is date..
and i want to convert that into date..
both the columns are in varchar format.. i need to convert it into date format.. i am not able to manipulate anything on these dates because of this format..
Pls look into this..
What you need is the TO_DATE() function.
regards for programmer which date store in varchars
when you need change datatype try this:
-alter table my_table add col_dT1 date
- update my_table set dol_dt1=to_DATE(orig_col1, 'dd/mm/yyyy hh24:mi:ss')
- drop orig_col1
rename col_dt1 to original name
Right; only, not all Oracle versions support column renaming.
thanks for all the valuable suggestions..