Mysql DateTime string to number

[ant_inter]

hey..i have a problem with mysql date-time string to number conversation.

Id like have conversation to number format for excel date.

My LV conversation for date 2013-01-22 10:00:00 is 3,44169E+9 and for

the same date in exel conversation is 41295,4166666667.

Why is that?

Tnx for yours explonations.

[Yamaeda · Accepted solution]

LV: "seconds that have elapsed since 12:00 a.m., Friday, January 1, 1904"

Excel: "days since 1st Jan 1900 00:00"

So you have a scaling factor of 86400 and of offset of 1461 days (assuming 1 scot year)

/Y

[ant_inter]

Tnx..I should know this

Tnx again 🙂