 |
|||||
 |
 |
 |
 |
 |
Let's Get Social! 
 |
|
||||||||||||
Focal Point Forums iWay Software Product Forum on Focal Point Oracle date format or month nameGo | New | Search | Notify | Tools | Reply | |
| Oracle date format or month name | Login/Join |
| Member |
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 | ||
|
| Master |
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 |
 | Please Wait. Your request is being processed... |
|
Focal Point Forums iWay Software Product Forum on Focal Point Oracle date format or month name