Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> date in select statement

date in select statement

From: Peace <peace_at_japan.com>
Date: 15 Feb 2002 01:32:18 -0800
Message-ID: <277abc47.0202150132.5f819cdd@posting.google.com>


How can I use to_date function to display date column in a table. i.e I want to in select statement.
ex:

sql>select to_date(validityfrom ,'YYYYMMDDHH24MISS') from userrequest;

where validityfrom is a column with data type as date in table userrequest.

Thanx for suggestions. Received on Fri Feb 15 2002 - 03:32:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US