Focal Point
Oracle date format or month name

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/3711064022

March 28, 2007, 07:17 AM
DarrenH
Oracle date format or month name
Hi all,
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?

Thanks


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
March 29, 2007, 09:17 AM
jgelona
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.