I don't mean to start an argument here but my question was indeed a MySQL related question - "Update Orders set Date_Arrival = (what?)" as was every other database related question I posted on this forum in the past - although they all were integrated into ColdFusion tags.
CF has decent forums but the place for database related issues is here and I didn't know - and I still don't know for sure - that the value I got for the date 38341.6703819 was purely coldfusion - and I still doubt it was a purely Coldfusion one. i.e. HSBC have an online payment system which uses this format too...
So I hope no offense was caused and - yes - I did a lot of searching and experimenting before I posted my question.
you have a date calculation which produces 38341.6703819 as a datetime value?
what coding scheme is that?
if 38341 is number of days, then relative to what date?
is 6703819 the number of microseconds after midnight? picoseconds? femtoseconds?
FYI, for anybody that cares , that's the current date value using 1/1/1900 12:00:00AM as a starting point. The fractional part is based on an 86,400-second day. 38,341 days and 57,921 seconds later equates to 12/20/2004 4:05:21PM. You can use 2 functions in VB[A/Script/whatever] to transfer back and forth, CDate() And CDbl().