sqlite - sql lite change 41934 to 22 10 2014 -

i need alter change "41934" 22-10-2014. "41934"is located in [leverdatum]

i use

"update bron set [collumname]"

in start of sql conversion or exeption need delete somthing (like empty rows) utilize

"delete bron where"

in excel have alter cellularity standard date. bad isn't easy in sqlite.

could help me?

greets jasper

to interpret 41934 offset measured in days 31-dec-1899, utilize sqlite's date , time functions:

sqlite> select date('1899-12-31', '+' || 41934 || ' days');

or in case:

update bron set [leverdatum] = date('1899-12-31', '+' || [leverdatum] || ' days');

sqlite

Jaimee