incomplete date


Oracle/SQL newbie question:

If I do a query with JMP6 from WinXP to an Oracle database, one of the
columns, which "contains a date", shows up as "MM/DD/YYYY HH:MM:SS[AP]M",
e.g. "08/22/2006 2:00:00PM". JMP tells me, via column info that this is a
numeric data type, continuous, and the format that yields the above.

If I copy the query over to a Perl script, from Linux, to the same
database, using DBD-Oracle 1.18, either with fetchrow_array or
fetchrow_hashref, that same column comes out as DD-MON-YY and no time
whatsoever, e.g. "22-AUG-06".

How do I get the whole thing, i.e. date and time, and with the four digit
year?

-- HASM


.

Relevant Pages

  • Re: Transfertext enclose number fields in quotes
    ... software vendor who will be importing our data into an Oracle database. ... then export from that query. ... Docmd.TransferText acExportDelim,, strDoc, strExportFile, False ... How do I get my number fields enclosed in double quotes? ...
    (microsoft.public.access.externaldata)
  • Re: SQL Query Invalid operation
    ... > removed though they query is than able to output something. ... > Both tables are made up of values from an oracle database and are ... The tables from which these queries are extracting data, ... You've posted this message in the "modulesdaovba" newsgroup. ...
    (microsoft.public.access.modulesdaovba)
  • Fun with UTF-8 and Oracle
    ... I have an oracle database and matching client, ... use DBI; ... The function datasets_by_name invokes the query above. ...
    (perl.dbi.users)
  • Re: JDBC query for date datatype (Urgent)
    ... > I am forming a query thru JDBC for ORACLE database like this ... >if you see in this query, FIELD2 datatype is Date. ... >But in JDBC, ...
    (comp.lang.java.databases)
  • Re: Very Large Database, dont know what my options are
    ... Oracle Database and I would appreciate your help. ... get-go), the query ran for 4 hours, and I was cut off as Oracle has ... Aside from creating indexes on that table, what other efficiency ... You might me surprised at the speed improvement. ...
    (comp.databases.oracle.server)