sábado, 21 de abril de 2012 6:30
Can someone please guide on how to convert the excel formula =reporteddate/3600/24+DATE(1970,1,1) to a ssis 2008r2 derived column formula.
An example value for reporteddate would be 1328192834
Thanks in advance.
- Editado caloundrasteve sábado, 21 de abril de 2012 6:40 include sql version
Todas las respuestas
sábado, 21 de abril de 2012 15:11
The reportdate you are having is unixtimestamp.use following expression in derived column.
use following statement in your source query
select DATEADD (SECOND ,1328192834,'1970-01-01') as reportdate
martes, 24 de abril de 2012 7:47
Thank you very much for your reply, that did the trick, I am not near my pc atm, but I just had to change your syntax slightly (I think it was) select DATEADD ("S" ,1328192834,'1970-01-01') as reportdate
martes, 24 de abril de 2012 13:02
Don't forget to take the timezone into account
Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu