I've got an issue querying an Oracle table using a date parameter.
I am using an ODBC connection to the database (can't get Oracle adapter for 10g to work) so I don't think I can use the SQLORA commands, can I?
So what I am trying to do is to get the name portion of the month so I can query for a date such as '24-MAR-2007'. I have heard that this can be done using the HNAME function, but can;t seem to get this to work.
Any ideas or pointers?
Prod: Service Manager 5.5 - DataMigrator 7.6 - Win2K
Test: Service Manager 5.5 - DataMigrator 7.6 - Win2K
Local: DevStudio 5.5.3 - Management Console
- Windows XP SP2
I think I can help you but how is your field defined in the master and what does your code look like?
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
|Powered by Social Strata|