title: How to convert varchar into date datatype in inline functions sql
body: <pre><code>create table session12 
  (
       id int,
       name varchar(20),
       Dateofbirth varchar(20)
  );
  
  insert into session12 
  values (1, 'prashanth', '29/06/1995'),
         (2, 'rayala', '27/06/1997'),
         (3, 'rayala1213', '7/9/2000');
  
  create function inline_Getsession()
  returns table
  as
      return
          select 
              id, name,
              cast(Dateofbirth as date) as DOB 
          from session12;
  
  select * 
  from inline_Getsession();
  </code></pre>
  
  <p>Output:</p>
  
  <blockquote>
    <p>Conversion failed when converting date and/or time from character string.</p>
  </blockquote>