Hi
I have a field that is secounds from 1. jan 1900 - And I convertede this to a date, but making selections on this date seems to course problems.
I have a field that is secounds from 1. jan 1900 - And I convertede this to a date, but making selections on this date seems to course problems.
Code:
select alarm_ID, DateAdd(Second, create_date, '19700101') As CreateDate
from WM_MultiCenterIntegration
where CreateDate > '2007-11-07'
order by CreateDate desc
ERROR said:Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'CreateDate'.