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
