I want to calculate with Dates and Times in SQL, but I have noticed that if I do
Select CONVERT (real, Current_Timestamp), Current_timestamp
gives me this
41700.52 2014-03-04 12:31:29.830
And in Excel it is
41702.52 3/4/14 12:29
As you can see, Excel is two days further when the number is not a date.
What is the correct number for a date?
Next question is, how can I convert a current time into a more accurate numeric value. As I also want to calculate with time
Select (1/(SUM(Rows)/1846415)) * (CURRENT_TIMESTAMP - '2014-03-04 10:51:00.380')
does not work