Hi Guys,
My IT staff have me connected to an Oracle database and the data looks ok until I attempt to use dates. The problem is that the Oracle database stores the date as a date time variable and this is not recognised at some point. To work around this I used Proc SQL and the Trunc function (e.g. trunc(loggedintime,"MI")), which worked well to the minute, however I need to be able to view the seconds also. Has anyone experienced this in the past and have any idea on how to rectify this issue?
Thank you in advance.
Regards,
Scott