Re: ORACLE DATES - How to use them

On May 3, 8:10 am, tracy <usatr...@xxxxxxxxxxx> wrote:
I am pulling data from Oracle into MS-Access, when run all of the date
fields are just a lot of numbers and not dates, if I link them in
Access or pass through query it is the same.

I get numbers like 1178002042 in the date field.

How do I write the SQL so this NUMBER is returned as date and time
information ?

I tried todate() but got errors when I tried to run, is todate() the
only way or am I missing something ?

Here is an example...

SELECT DISTINCT "ref_num", "open_date"
FROM "View_Issue_to_Issue_Act_Log"
WHERE ("ref_num"='15632407')

Trying to add criteria to pull records only if open_date is within the
last two days.

Thanks

Access is capable of working with Oracle dates.
Apparently your dates are not real dates.
That being said, you post insufficient information
One would need
exact version of Oracle
exact version of Access
the ODBC driver involved and it's exact version
The results of DESC <table_name> from Sql*plus.

Without this information an adequate reply is impossible.
Right now you could just have well posted 'It doesn't work. Help'

--
Sybrand Bakker
Senior Oracle DBA

.

Relevant Pages

  • Re: Dates on an Access Report
    ... as (FromDate and toDate)? ... but some other field in the query. ... The two exact dates entered by the user on the form when the report ...
    (comp.databases.ms-access)
  • Re: Interpreting cost on EXPLAIN PLAN
    ... Jonathan Lewis wrote: ... I will get the exact version when I get back to work tomorrow. ... cost or the total cost of the statement? ... > Now waiting on the publishers: Cost Based Oracle - Volume 1 ...
    (comp.databases.oracle.server)
  • Re: Encryption
    ... you determine the EXACT steps you need to take. ... This my be far off from what Oracle needs, ... I would assume that the Oracle designers have made this ... quite tricky to avoid hacking their passwords. ...
    (perl.beginners)
  • Re: Anyone know how to call an Oracle function from C#?
    ... "Steve Kershaw" wrote in message ... When will Oracle ... This is the exact same block you can use in SqlPlus. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: RMAN Duplicate Question
    ... You did not see my suggesting that, because you have proven quite a few ... Heck, I pointed you to the exact place, by quoting the exact text. ... You should stop blaming Oracle and others for your own incompetency. ...
    (comp.databases.oracle.server)