Convert int to datetime
how can i convert a field contain data 733803 as into 开发者_开发知识库be datetime on sql server?
What data is 733803? Is it a unix timestamp? If it is the answer is below.
select dateadd(ss, 733803, '1970-01-01')
You can simply cast from integer to datetime like so:
declare @outDate as datetime
set @outDate = CAST(@integerValue as datetime)
Of course, that presumes that your integers are valid sql integer representations of datetimes and will probably also depend upon regional settings of the servers you are running this on.
For example, the integer you provided converts to a date in 3909 on my sql server, so perhaps there is something else going on in the generation of that int?
精彩评论