substr of datetime as char field from MYSql table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Working with Oracle » substr of datetime as char field from MYSql...

substr of datetime as char field from MYSql table

Rate Topic

Display Mode

Topic Options

Author

Message

TryingToLearn

Posted Wednesday, January 02, 2013 1:19 PM

Grasshopper

Group: General Forum Members
Last Login: Today @ 8:33 AM
Points: 23, Visits: 167

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

Post #1402059

« Prev Topic | Next Topic »

Permissions