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

On May 3, 8:10 am, tracy <usatr@hotmail.com> wrote:

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

-----------------------------------------------Reply-----------------------------------------------