Results 1 to 3 of 3

Thread: Date & Time

  1. #1
    Join Date
    Mar 2004
    Location
    Ireland
    Posts
    4

    Unhappy Unanswered: Date & Time

    Hi,
    Im having a problem getting the date and time function in oracle.
    my table is as follows,
    Create table dates (v_date DATE );

    INSERT INTO dates values(To_date ('23 February 2003 10:51', 'DD Month YYYY HH:MI'));

    which is all fine, but when i do a select on that table i just get the date back... i need to have the time as well, as later i will be checking it in order to meet some requirements,
    anyhelp would be appreciated,
    thanks,
    Brian

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    SELECT TO_CHAR(v_date,'DD-MON-YY HH24:MIS') FROM DATES;

    hth
    Gregg

  3. #3
    Join Date
    Mar 2004
    Location
    Ireland
    Posts
    4

    Cool

    sound, that has only taken me four hours.....
    i tried so many different things i cant believe i missed that one....
    cheers
    Brian

Posting Permissions

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