Skip to Content
0
Former Member
Sep 25, 2012 at 04:38 PM

date conversion in sap hana

2867 Views

HI all,

i have a data in my table where my datefield is a varchar 8.

date is stored as 19750112

i am trying to convert a into a date and daysbetween

like select days_betweem(dob,now()) as age from table1.

this is the error i am getting.

[303]: invalid DATE, TIME or TIMESTAMP value: Error while parsing DATE/TIME at function to_date()

can someone help me out please.