sql - How to convert decimal to date? -

sql - How to convert decimal to date? -

i have problem. have field start_value info type decimal. want convert decimal date.

the info type start_value decimal.the info of start_value :

start_value |=========| | 240368 | | 198448 | | 197396 | | 126743 |

i want convert datetime , want expect 'yyyy-mm-dd 00:00:00.000'

i don't know if value julian date or else. please help me find right select query. thanks.

you can utilize next query in sql server parse datetime

select convert(datetime, substring(cast(start_value varchar(8)),1,2) + '-' + substring(cast(start_value varchar(8)),3,2) + '-' + substring(cast(start_value varchar(8)),5,2),5) datetimevalue table

if using oracle can utilize next query

select to_date(cast(start_value varchar(8), 'ddmmyy') table

sql date decimal valueconverter