[thesite] Tips Database

[Dean Mah]

Seth Bienek writes:

> > > I would like it if the 'hdr_date' field were a date-time field
> > 
> > Done.  Selecting from the server will give you the time in CST.
> 
> I don't see the time in the date field.  Did it make it into the
> database?

It's likely because the default NLS_DATE_FORMAT is something like
YYYY-MON-DD.  You can alter your session and set it to something else
or in your query use TO_CHAR to convert it into a character string.
For example,

   SELECT TO_CHAR(hdr_date, 'YYYY/MM/DD HH24:MI:SS') FROM thelist;

Dean