var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to Convert Varchar2 to Date format(Timestamp)
I have a date saved in varchar2 column.
how can I convert the values into date(including Time stamp), so I can use the date to compare data.
Ex: I have the value '20-03-2007 05:31:29', but this value is saved as varchar2.
how can I take from this value the date '20-03-2007 05:31:29' as date format because later i need that date completely to add days, hours and minutes?
Use TO_DATE function with the appropriate format mask, such as
Note that it might fail if invalid values are entered into the table; for example, non-existent month if someone entered 03-20-2007 instead of 20-03-2007 and similar.
to_date(your_column, 'dd-mm-yyyy hh24:mi:ss')