数据库管理器类的设计模式(Design pattern for database manager class [closed])

 OK玩弄它显示了它和jQuery日期的答案完全一样。 你以0x开头的数字部分。 
 
 
 
 在0x之后取10个数字。 例如在A2： =MID(A1, 3, 10) 
 
 
 将其转换为十六进制，例如A3： = HEX2DEC(A2) 
 
 
 除以86400，例如A4： =A3/86400 
 
 
 并将结果添加到1/1/1970日期。 例如= A5： =A4 + Date(1970, 1, 1) 
 
 
 或简而言之： 
 
=(hex2dec(mid(a1,numstart,10))/86400) + date(1970,1,1)
 
 用numstart的1开始索引替换numstart 。 
 
 例如3，如果你有一个12或13位数字，如0x12345678AB，你会得到12345678AB 
 
 这与在Excel中转​​换JSON日期/日期（1388624400000）/日期类似 
 
 除了那个： 
 
 一个。 这个问题被回答错误，并且不起作用。 （我编辑它） 
 
 湾 .sql文件是通过SQL从数据库的存储过程中检索的。 虽然在他们使用jQuery返回的Ajax数据，这似乎是不同的问题。 原来他们是不同格式的相同号码。 
 
 作为补充说明，我在我的十六进制数字的开头有一个空格标记。 在我做了MID之前，我没有看到它。 
 
 注意：使用ajax返回的格式化日期（例如/ date：0x12345678ab /）时，您将numstart设置为8.如果hex2dec失败，请尝试在调用hex2dec之前将十六进制字符串转换为大写。 要调试只是把每个公式放在一个单独的单元格中，所以你会看到什么有效，什么不可行。 

OK Playing around with it showed me that it's exactly the same as the jquery date answer. You take the numeric portion starting with 0x.
 
 
 
Take the 10 digits AFTER the 0x. e.g. in A2: =MID(A1, 3, 10)
 
 
Turn it into hexadecimal e.g. in A3: = HEX2DEC(A2)
 
 
Divide by 86400 e.g. A4: =A3/86400
 
 
And add the result to 1/1/1970 date. e.g. = A5: =A4 + Date(1970, 1, 1)
 
 
Or in short:
 
=(hex2dec(mid(a1,numstart,10))/86400) + date(1970,1,1)
 
Replace numstart with the 1-starting index of the number. 
 
e.g. 3 if you have a 12 or 13 digit number like 0x12345678AB and you'll get 12345678AB
 
This is similar to the Convert JSON Date /Date(1388624400000)/ to Date in Excel 
 
Except that: 
 
a. The question was answered wrong and wouldn't work. (I edited it)
 
b. The .sql file was retrieved in a stored procedure from the database via SQL. While in the question they were using jquery returned ajax data, which seemed to differ. Turns out they're the same number with a different format. 
 
As an added remark, I had a space mark at the beginning of my hex number. Until I did the MID on it, I didn't see that. 
 
Note: When using ajax returned formatted dates like /date:0x12345678ab/ you'll set numstart to 8. If hex2dec fails, try turning the hex string into uppercase before calling hex2dec. To debug just put each formula in a separate cell, so you see what works and what doesn't.