DB2 - SQL help plz - Basic

[Sambadu]

       SELECT   CAST ( CAST ( '19470815' AS varchar(8)) as DATE )-- SQL server lo vastundhi data 

 

BUT DB2 lo enduku ravtledu.. CAST ( CAST rayalema??

 

na original requirement decimal (8) undhi so date ki convert cheyali.. direct date ki thesukovadam ledu anduke ela chestuna.. 

[tortoise]

[vikuba]

date length 10 characters kadha with dash or slashes

8 ani unchaav...is tht causing issue?

[Bhai]

40 minutes ago, Sambadu said:

       SELECT   CAST ( CAST ( '19470815' AS varchar(8)) as DATE )-- SQL server lo vastundhi data 

 

BUT DB2 lo enduku ravtledu.. CAST ( CAST rayalema??

 

na original requirement decimal (8) undhi so date ki convert cheyali.. direct date ki thesukovadam ledu anduke ela chestuna.. 

nuvvu emi rasav??

 

error message ento veyyi

[Suhaas]

What version of DB2 are you working with Bro?

use to_date function

Select date(to_date(col_name,'DD-MM-YYYY HH:MI:SS')) from table