Skip to Content
Sep 29, 2016 at 04:54 PM

How does date conversion function work?


Hi All,

I am trying to run below query in Sybase IQ where its giving error "Type conversion is not possible"

select date(trim(<Column A>) from Table_1

where as the below query is not throwing any error

select date('20150101231011') from dummy

Column A consists of same kind of data.

How does date function exactly work?

Thanks and Regards

Srujan Gannamaneni