attribute date of type numeric to datetime...!

hi everyone..!!

how can I turn an attribute date of type numeric of a table and pass it to another table (using SSIS) as datetime

Can you provide an example of what those 'dates' look like?

/Kenneth

|||There is a special SSIS forum, you may be better using that. One way however would be to use CAST or CONVERT and create a view which converts the current date to correct format.|||

The 'trick' is usually, that if the 'date' is stored as a number, you must find out what the numbers represent. eg 12345 - is this seconds, minutes, hours? And counting from when?

Once you know the time-unit the numbers are using, and the starting point, you can use the datefunctions to do date arithmetics on the 'number'.

/Kenneth