从MSSQL到其他的日期格式

Question

In MSSQL I have columns with date (only date, without time). It was saved with this function:

ROUND(CAST(GETDATE() AS REAL), 0, 1) + 36163 **(ex. 77009)**

How I can format this date (month etc.) with PHP, MySQL or even MSSQL.

For example: 77009 = 2011-11-01.

Answer 1

For Sql Server SELECT CONVERT(DateTime,XXX-36163)

eg. SELECT @val = ROUND(CAST(GETDATE() AS REAL), 0, 1) + 36163 SELECT CONVERT(DateTime,@val-36163)