I connect to an Oracle database via a linked Server in SQL Server 2005.
I call a function in Oracle
ARADMIN.fn_adjusted_date(ac.SCHEDULED_START_DATE) as Scheduled_Start_Date,
That returns a date format in the following format
Mar 26 2011 1:00AM
Is there a function I can call in Oracle that will return the following format
Mar 26 2011 13:00