DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: URGETNT !! Oracle date format millisecond

  1. #11
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Code:
    SQL> create table my_table(my_comment VARCHAR2(100),
      2  my_date_with_milliseconds VARCHAR2(25));
    
    Table created.
    
    SQL> insert into my_table values
      2  ('The time in millisecs I''ve got from somewhere',
      3  '2002-08-26 16:42:37.226');
    
    1 row created.
    
    SQL> select * from my_table;
    
    MY_COMMENT
    --------------------------------------------------------
    MY_DATE_WITH_MILLISECONDS
    -------------------------
    The time in millisecs I've got from somewhere
    2002-08-26 16:42:37.226
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  2. #12
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Nice
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

Posting Permissions

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


Click Here to Expand Forum to Full Width