date_format

From: luke (growler8_at_hotmail.com)
Date: 01/27/04 

Date: Tue, 27 Jan 2004 12:12:42 -0000

I have some data in an oracle database which has a data type of DATE and the
dates are stored as 2004-01-20 17:43:49.0

When I get that information via PHP it outputs as 27-JAN-04

Does anyone know how to change this format as I want the time displayed as
well? I have tried an SQL statement of
SELECT DATE_FORMAT(date_column, '%l %i %m %d %y') but this doesn't seem to
work with an Oracle thin client.

Does anyone know an alternative (perhaps using the date() function???) or is
there a standard date setting you can change so everything outputs with the
time showing?

Relevant Pages

  • Re: how to get datatype of columns of a table in perl script
    ... I am developing perl script which connects to oracle database and selects rows from a table and then inserts them into its corresponding table in db2. ... Any database should be able to handle this regardless of the data type. ... A great introspection feature. ...
    (perl.dbi.users)
  • Re: how to get datatype of columns of a table in perl script
    ... >>which connects to oracle database and selects rows from a table and then ... > A simple generic solution is to just quote all literal values, ... > this regardless of the data type. ...
    (perl.dbi.users)
  • RE: Errors while inserting into long data type
    ... > Hi Friends, ... > I am using oracle database and I have column of long data type. ... Ronald ...
    (perl.dbi.users)
  • Acess & Oracle Unicode Problem
    ... All is fine until I access a particular field whose data type is described in the linked Oracle table as Memo. ... My query includes other Memo fields but they are extracted correctly. ... When the problem memo field is queried I get an error message: ... Any idea if there is a problem with the data or is it my means of accessing the Oracle Database? ...
    (microsoft.public.access.externaldata)
  • MS Access to Oracle via ODBC
    ... All is fine until I access a particular field whose data type is described in the linked Oracle table as Memo. ... My query includes other Memo fields but they are extracted correctly. ... When the problem memo field is queried I get an error message: ... Any idea if there is a problem with the data or is it my means of accessing the Oracle Database? ...
    (microsoft.public.data.odbc)