Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    6

    Unhappy Unanswered: to_date, to_char implementation

    I have a problem with retrieving the rows

    I created a table with an attribute 'time'
    SQL> create table testdate(time date);

    I inserted the values of time using the To_Date function
    insert into testdate values(To_Date('06:20', 'HH24:MI'));

    I selected all the rows, but the time attribute displays the date as shown below:

    SQL> select * from testdate;

    TIME
    ---------
    01-MAY-03

    My query is: How to retrieve the rows in time format, rather just date.

    Thank You

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    select to_char(time,'HH24:MIS') from testdate;

  3. #3
    Join Date
    May 2003
    Posts
    6

    Thanks

    Thanks, it works.

    Smoove

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •