var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: covert char to date
i have a char column which is having date in it
while trying to convert to date its not working
any way to covert
select pol_dt from tpol
pol_dt is a char column
when we do
select date(pol_dt) from tpol its giving
replace the '/' with '-'
select date(replace(pol_dt, '/', '-')) from tpol
thax wilson for the reply
but its giving the same o/p
select date(substr(pol_dt,1,4) || '-' || substr(pol_dt,5,6) || '-' ||
substr(pol_dt,7,8)) from tbname
its not working
Paul, Your SUBSTR values are incorrect for the Month and Day.
The Month starts in position 6 for 2 characters and the Day starts in position 9 for 2 characters.
DATE( SUBSTR(POL_DT,1,4) || '-' ||
SUBSTR(POL_DT,6,2) || '-' ||
substr(pol_dt,5,6) means substring starting from position 5 with length 6.
Originally Posted by Mathew_paul
Not the characters in position 5 and position 6 how you are thinking.