Convert integer to datetime

[dinadulcer]

I have a software that save's datetime into an integer field. For example:

21 Fev 2007 09:45:07 --> 745083669
21 Fev 2007 10:19:39 --> 745182735
22 Fev 2007 10:08:14 --> 745185806
22 Fev 2007 10:08:17 --> 745185809

I like to know how to convert interger field to datetime type.

Any help will be greatly appreciated, thanks in advance

[dorinbogdan]

It seems that the program is using a reference date, and return the difference between a second date and reference date in seconds.

Compare the result of this query against your values:

SELECT DATEADD(ss, 745083669, '07/13/1983 18:03:58')
, DATEADD(ss, 745182735, '07/12/1983 15:07:24')
, DATEADD(ss, 745185806, '07/13/1983 14:04:48')
, DATEADD(ss, 745185809, '07/13/1983 14:04:48')
 

[almaz]

Integer values don't look like datetime values, at least using standard transformation logic. Standard transformation logic is to store the number of units (seconds/minutes/hours/whatever) between particular datetime value and required one, and it can be easily determined by searching for proportion between datetime and integer values, but your sample doesn't have it.

[dinadulcer]

Tanks for your help.

But i need to find out what datetime i will use to add the seconds.
Do you have a clue to do that?

HELP MEEEEE...

It seems that the program is using a reference date, and return the difference between a second date and reference date in seconds.

Compare the result of this query against your values:

SELECT DATEADD(ss, 745083669, '07/13/1983 18:03:58')
, DATEADD(ss, 745182735, '07/12/1983 15:07:24')
, DATEADD(ss, 745185806, '07/13/1983 14:04:48')
, DATEADD(ss, 745185809, '07/13/1983 14:04:48')
 

[dorinbogdan]

It seems that your values are based on 3 different reference dates, so it is not fixed:
07/13/1983 18:03:58
07/12/1983 15:07:24
07/13/1983 14:04:48
07/13/1983 14:04:48

You should better analyze that program or contact the author in order to provide out the algorithm that generates the reference dates.