substr of datetime as char field from MYSql table

• TryingToLearn

  SSCrazy

  Points: 2645

  More actions

  January 2, 2013 at 1:19 pm

  #266661

  I am trying to extract just the time portion of the datetime field. i am creating a view in MYSql which will then be queried via an openquery statement form SQL Server and it needs to be a CHAR field.

  SELECT substr(`calldate`,12,8) AS 'TIME'

  FROM `asteriskcdrdb`.`cdr`;

  the calldate field is defined as datetime in MYSql. i need just the time portion and to save it as a CHAR filed for SQL Sever. as you can see I am clueless.

  Thank you

  calldate field: in table

  2013-01-02 15:10:41